Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try aggr(Rank(total (sum({1}Sales))),BRAND)
Try aggr(Rank(total (sum({1}Sales))),BRAND)
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
Hi Please find attached qvw.