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:
I created the variable
Custom_Ranking = 1+Previous(Self)
Also tried using the Running_Count variable
and filtered the table
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:
I only want to display Cat1-Cat5. Thanks in advance for your assistance.