cancel
Showing results for 
Search instead for 
Did you mean: 

Web Intelligence limit ranked rows to 5

jenszulinski
Explorer
0 Kudos

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.

Accepted Solutions (1)

Accepted Solutions (1)

jenszulinski
Explorer
0 Kudos

Hi,

I was able to limit to 5 rows using the following measure variable:

Top5 =FormatNumber([Measure];"00000")+[Dimension]

Then the ranking can be created based on Top5, ranked by [Dimension]

Answers (3)

Answers (3)

former_member241445
Participant
0 Kudos

you can use the rank controls to realize.you just need to choice the dimension or variable,and then choice the top you want to show.Hope can help you!

Former Member
0 Kudos

Yes Jen reason why it was failing previously is when you used Previous(Self) function and filtered out the data the values for the Previous() got changed due to applied filter and changed data value.

Regards

Niraj

mhmohammed
Active Contributor
0 Kudos

Hi Jen,

Please try and post your next question regarding Webi/Desk on this page. 🙂

Thanks,

Mahboob Mohammed