Skip to Content
0
Oct 13, 2016 at 04:54 PM

Web Intelligence limit ranked rows to 5

266 Views

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.