I want to show the ranknummer of severel sum() conditions like:
What is the righr expression for this dimension ?
If u are using 'rank' it is showing u the position of your Dimension in respect to its value....
so if u dont need the sum value, just want to see the position then use rank.
I have attached a simple example with the ranking expression =Rank(sum(Amount))
Please check the attached qvw reflecting the same-
thanks guys, I was trying with aggr() and rank() , but only rank(sum(x)) is enough. thanks yall
Retrieving data ...