Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi
i need to have some label that when i click on each branch id, it shows the rank of the sale
for example my data like this:
Branch_ID | Sale |
---|---|
100 | 1250 |
101 | 1452 |
103 | 1301 |
when i click on 101 my lable should show 1 and when i click on 100 it should show 3
what should i do?
May be this,
='Rank ' & Num(Aggr(Rank(Sum({1} Sale),4),Branch_ID))
Hi,
I hope it will helpful for you.
Try like this
Aggr(Rank(Sum({<Branch_ID=>} Sale)),Branch_ID)