Sort within a ranked table

building reports desktopintelligence
1

I am attempting to do a A-Z sort within a table that has a top 3 rank applied.

When I try to apply the sort you get asked to overwrite the filter already applied (the rank).

Does anyone know of a work around

Grizzly-Law :uk: (BOB member since 2004-07-01)

2

Just wondering why you need that. When Rank is applied, that means you are sorting based on may be sales. In such a case if you sort by AtoZ, you will lose the purpose of Rank.

Rgrds,
Shobhna.

Shobhna (BOB member since 2003-11-19)

3

Difficult to explain without showing the report. But an example would be …

In Island resorts

Resort
Service
Revenue
No Of guests

Rank resort by revenue
A/Z Sort on No Of Guests

Grizzly-Law :uk: (BOB member since 2004-07-01)

4

So you are trying to rank the top 3 of one column and sort these 3 entries by a different column? You might be able to define a complex filter on the ranked column instead of the ranking - only you would know this because you know your data.

5

I have a cunning solution which might work for you.
E.g You want to Rank on Resort for Revenue to show top 10 rows.
By default BO will put the result in alphbatical order of Resort.

But if you want to sort these 10 records on Service Column,
Create a variable.

=SubStr(<Service> ,1 ,1) &amp; <Resort>

Now apply your Rank on this variable instead of Resort.

mkumar (BOB member since 2002-08-26)

6

So cunning Baldrick would be proud. :smiley:

Cheers I’ll give it a go.

Andrew

Grizzly-Law :uk: (BOB member since 2004-07-01)