Top 6 Max Sales

[Anonymous]

Hi Guys,

I am trying to show top max sale, I have two dimensions Region and Company. I have descending order top max to lower sales.

I am trying to put this on dimension level.

=aggr(if(

max(rank(Sum({$<Month={$(=Month)}>} Sales)))

>=

max(rank(Sum({$<Month={$(=Month)}>} Sales))-5), Company) , Region, Company)

Could you please advise me what I am missing?

Kind regards,

Farrukh

[sunny_talwar]

Top 5 sales overall or top 5 sales per Region?

[Anonymous]

Top 6 sales overall

[sunny_talwar · Accepted solution]

May be this:

=Aggr(If(Rank(TOTAL Sum({$<Month={$(=Month)}>} Sales)) < 7, Company), Region, Company)