Ranking top 10

[KPage]

Hi,

I would like to only include the top 10 items in sales. Here is by Retail Sales expression below, with an image of the fields I am using in my table

Sum({<[Week Ending]={'$(=Max([Week Ending]))'}>}[Retail Sales])

Is there a place in the expression where I can add a Rank formula?

Thank you!

[rbartley]

Hi @KPage ,

Have you tried setting a Fixed number limitation on the dimension(s)?

[KPage]

I have, but there's no option in the dropdown. It also is not working correctly when I do set a limitation to Retailer SKU

Retailer SKU limitation setting

[rbartley]

You can't set a limit on the measure, only the dimension.  What do you mean when you say you tried applying the limit but it didn't work?  What didn't work?

If you could supply an Excel sheet with some representative data, it would be easier to advise.

[rbartley]

Alternarively, have you tried using the aggr() function as in this post in order to specify over which dimensions the measure should be ranked?: https://community.qlik.com/t5/QlikView-App-Dev/Rank-within-a-specific-dimension-when-you-have-multip...

[KPage]

Here is a screen shot-Limitation is set, and is still showing more than the top 10 sales.