Have a category report that I need to limit to the top 5 rows based on count. When I rank and there are matching counts between categories I get more than 5 rows. When I filter by ranking <=5 I still get more than 5 rows.
I tried the suggestions on the following post with no luck:
http://archive.sap.com/discussions/thread/3778944
I created the variable
Custom_Ranking = 1+Previous(Self)
and filtered
Custom_Ranking <=5
Also tried using the Running_Count variable
if(RunningCount(dimension)<=5;1;0)
and filtered the table
Running_Count<=5
When I do that I get 5 different categories that are not in the top 5.
Below is an example of what I'm working with:
Dimension/Rank/Measure
Cat1/1/10
Cat2/2/9
Cat3/3/8
Cat4/3/8
Cat5/4/7
Cat6/5/6
I only want to display Cat1-Cat5. Thanks in advance for your assistance.