Keeping rank static...

[rohitians]

Hello,

I have this pivot chart where in have brands of different commpanies with their sales..

i have a rank code where in displaying rank according to the sales...

When i select a certaian company and suppose it has three brans with different ranks....but the ranking starts again from 1 and so on...

I want that even if i select brand or company the rank for that brand should remain static...

I am attaching sample data...

Thanks and Regards,

Rohit Yadav

[Gysbert_Wassenaar · Accepted solution]

Try aggr(Rank(total (sum({1}Sales))),BRAND)

[rohitians]

Hello,

It is working for the sample data but not for the actual one...

=Rank(total (SUM( {$<FiscalYear={$(=max(FiscalYear))}>} [Values])/10000000))

Thanks and Regards,

Rohit

[Anonymous]

Hi Please find attached qvw.