rank

[omid5ive]

i want something like this:

rank(sum({<Branch_Code={1}>}sales))

what should i do?

[Kushal_Chawda]

what set analysis condition you are trying to put?

[omid5ive]

it shows this

[sunny_talwar · Accepted solution]

My bad, try this:

Only({<Branch_Code = {1}>} Aggr(Rank(Sum(Sales)), Branch_Code))

Only({<Branch_Code = {2}>} Aggr(Rank(Sum(Sales)), Branch_Code))

Only({<Branch_Code = {3}>} Aggr(Rank(Sum(Sales)), Branch_Code))

[omid5ive]

branch_code=1 or some other values

i want to have multi text box that contains the rank of each branch

[omid5ive]

Thank you Sunny