Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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:
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: