How do I show the Nnth best dimension with set analysis?

[julioarriaga]

Hi,

I have a table of sales by country. How can I show only the Nnth best selling country with set analysis (as shown in the example)?

Thanks and regards.

[tresesco]

Try like:

Sum({<Country={"=Rank(Sum(Sales))=5"}>}Sales)                  // n is 5 here