show rank number within sum() conditions

[#1]

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.

[santhoo_san]

=Rank(sum(Amount))

[help4qv123]

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.

[awhitfield · Accepted solution]

HI Tobias,

I have attached a simple example with the ranking expression =Rank(sum(Amount))

HTH

Andy

[Digvijay_Singh]

Please check the attached qvw reflecting the same-

[#6]

thanks guys, I was trying with aggr() and rank() , but only rank(sum(x)) is enough. thanks yall