Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i want something like this:
rank(sum({<Branch_Code={1}>}sales))
what should i do?
what set analysis condition you are trying to put?
it shows this
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))
branch_code=1 or some other values
i want to have multi text box that contains the rank of each branch
Thank you Sunny