Rank on SubTotal with respect to Grand total

[akar_0308]

Hello ,

Could you please help to get a rank like for Example

Country -France , Rank of City would be Paris = 1,Lyon=2, Nice=3

but SubTotal rank would be 2 as it is 29.49% according to Grand total.

I have attached the document

[MayilVahanan · Accepted solution]

Hi @akar_0308 

Try like below

If(RowNo()=0, Aggr(Rank(Sum(TOTAL<Country> [Count of Sales])), Country), Aggr(Rank(Sum( [Count of Sales]),4,1),Country, City))

output: