ranking

[omid5ive]

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?

[tamilarasu · Accepted solution]

May be this,

='Rank ' & Num(Aggr(Rank(Sum({1} Sale),4),Branch_ID))

[muthukumar77]

Hi,

I hope it will helpful for you.

[MayilVahanan]

Try like this

Aggr(Rank(Sum({<Branch_ID=>} Sale)),Branch_ID)