Rank for 2 levels in text box

[dafnis14]

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!

[sunny_talwar · Accepted solution]

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)

[dafnis14]

Sunny,

Thanks so much for always being so helpful!

[sunny_talwar]

No problem at all