Help!!!! Rank with a filter

[jm134]

I've got a block of data that I want to filter down to 3 brand types using a global filter. But I want to rank the results against ALL the brands. I.E. if brand one is 64th overall but 2nd in the filtered list, I want 64 as the results. This is a hot one,, if someone has a solution, I'd love to hear it. Thanks in advance.

 

[blom0344]

Puzzling. What is your global filter definition?
How do you establish that a brand is 64th in the first place (through lining up a measure?)

Elaborate a bit more on the details please....

T. Blom
Information analyst
tbl@shimano-eu.com

 

[jm134]

Lets say I have 64 brands. I put a global filter on brand to just show 3 of them. So now I've narrowed my block of data down to 3 items. If I rank them as is,, they will be ranked 1-3. If I have no global filter I have 64 brands and if I use the rank commnad I will have 1-64. I want to use a global filter to show just 3 of the brands and but rank them against the entire 64.

 

[skrandel]

Turns out to be very easy.

Use the NoFilter function around your Rank Function.

For example, =NoFilter(Rank(<Brand> ,<Sales revenue>))

Steve Krandel
Westbay Solutions

http://www.westbaysolutions.com

 

[jm134]

Try that nofilter with a break included on the brand??? That's my problem.

 

[skrandel]

I did. It worked fine.

Report Title
Lines Category Sales revenue
2.00 Accessories Belts,bags,wallets $1,642,492
2.00 Hair accessories $350,919
2.00 Hats,gloves,scarves $1,550,563
2.00 Jewelry $5,180,094
2.00 Lounge wear $541,179
2.00 Samples $649,298

Lines Category Sales revenue
10.00 City Skirts Full length $210,578
10.00 Mini city $137,197

Lines Category Sales revenue
11.00 City Trousers Bermudas $105,171
11.00 Long lounge pants $179,563


Steve Krandel
Westbay Solutions

http://www.westbaysolutions.com