Set analysis

[deepakqlikview_123]

I want to show sum of sales for top 20 city can you please tell me how to do that using set analysis

[swuehl]

Isn't this the same question as in your other thread? Please try to avoid duplicate posts.

Try

=sum({<City = {"=rank(sum(Quantity))<=20"}>} Quantity)

[#3]

Sum(Sales) in expression...

In Dimension limit tab--> Check limit the number of values to be shown

-->Choose show only--> Select Largest and give 20 as value