Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I want to show the ranknummer of severel sum() conditions like:
ID1 | Amount |
---|---|
1 | 11 |
2 | 22 |
2 | 33 |
3 | 44 |
ID | rank(sum(Amount)) ??? | sum(Amount) |
---|---|---|
1 | 3 | 11 |
2 | 1 | 55 |
3 | 2 | 44 |
What is the righr expression for this dimension ?
thx.
HI Tobias,
I have attached a simple example with the ranking expression =Rank(sum(Amount))
HTH
Andy
=Rank(sum(Amount))
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.
HI Tobias,
I have attached a simple example with the ranking expression =Rank(sum(Amount))
HTH
Andy
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