🎉Community Raffle - Win $25

An exclusive raffle opportunity for active members like you! Complete your profile, answer questions and get your first accepted badge to enter the raffle.
Join and Win

Compute rank within subgroups

User: "keith"
New Altair Community Member
Updated by Jocelyn
Is there an operator that will compute the rank of each row according to some attribute value?  If so, is it possible to do so for subgroups within an example set?

e.g.  Compute RANK based on VALUE within each GRP group
GRP ID   VALUE   RANK
1  a    5      1
1  b    10      2
1  c    20      3
2  d    7      1
2  e    50      2
2  f    51      3
Thanks.
Keith

Find more posts tagged with