Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a problem to achieve the following:
I have a shop which is linked to an area.
I would like to show for a selected shop two figures in two separate text objects:
1 - the shop's rank in the area it belongs to
2- the shop's rank in all the chain
Attached is a very small sample data.
Thanks in advance!
Try these:
='Overall Rank :' & Aggr(Rank(TOTAL Sum({1}Sales)), Area, Shop)
='Rank in Area :' & Aggr(Rank(TOTAL Sum({<Shop, Area = p(Area)>}Sales)), Area, Shop)
Try these:
='Overall Rank :' & Aggr(Rank(TOTAL Sum({1}Sales)), Area, Shop)
='Rank in Area :' & Aggr(Rank(TOTAL Sum({<Shop, Area = p(Area)>}Sales)), Area, Shop)
Sunny,
Thanks so much for always being so helpful!
No problem at all