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?
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))
Your requirement is not clear... please provide some more information.
I don't see any issue with the expression you have above. Is it not working?
i need to set some condition on my ranking but i think in rank function i cant use set analysis
i want to see the rank of sale for each branch in some text box
You already have it . Just you need to load some data in your file and plot the chart with this expression.
Condition as in Set Analysis? Use that in the Sum function rather than Rank.
are you sure in rank function i can use set analysis?
because in my dashboard i cant use it
it will show nothing
For text box, you might need to do like 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))
....
and so on for each of your Branch Code
in my case it will show 1 every time