Multiple ranks in a table

building reports webintelligence
1

Hi All,

I’m trying to build a table with one dimension (e.g. region) and 3 measures (A,B,C).
The table should be ranked by the ‘A’ measure (top-10) - this is not a problem.

I also need to display the ranks for ‘B’ & ‘C’ measures. I try to use the “Rank” function, but it seems to calculate the rank of the region within top-10 list (based on ‘A’ measure) but not within the general list of regions.

How I can make it use the general list of regions?

Thanks,
Dmitry

Dmitry Grekov :ru: (BOB member since 2009-09-29)

2

Hopefully I’ve just almost find the solution.

NoFilter(Rank([B];Top)) works almost fine, but it eliminates not only the filter applied by the ranking, but any other filters as well (the table is also filtered to display the current year).

The workaround I see right now is to move any other filters from the table level to the measure level, i.e. [B] -> [B] Where ([YearsAgo] = 0) and etc. But this solution is not perfect. I’d appreciate if anyone has a better one.

Thanks,
Dmitry

Dmitry Grekov :ru: (BOB member since 2009-09-29)

3

I’m also getting that same issue. Have tried the same sort of thing with no luck. My problem is I’ve for the report sectioned, so the nofilter is looking at all the sections to get the ranking…not within the section.

mjyoungman :australia: (BOB member since 2006-10-06)

4

Actually I got it to work… here’s the formula I used…

=NoFilter(Rank([Sales LY];[Product];([Region])))

Note that Sales LY was the second measure I was ranking, Product is the dimension I’m ranking, and Region is the Section I have in my report.

mjyoungman :australia: (BOB member since 2006-10-06)