Top 30 merchants

[#1]

I took Merchant as dimension and sum(Sales) as my expression. And also suppressed the null values for Merchant. I got the total as 123030099402.72.

I want to display the sum(Sales) of the top 30 merchants by Sales in a text box as well.

So I did =sum({<Merchant = {"=Rank(sum(Sales)) <=30"}>}Sales).

But I got a very weird value of 32428895761.17. Is it because of nulls.

What is the correct expression in a text box for sum(Sales) for largest 30 merchants excluding nulls?

[sunny_talwar]

What if you do this?

=Sum(Aggr(Sum({<Merchant = {"=Rank(Sum({<Merchant  -=  {' '}>}Sales)) <=30"}>}Sales), Merchant))