I've similar requirement but i need to reset ranking at each student level for each subject
101 - Maths -1
101 - Science-2
101 - English-3
102 - Science-1
102 - English-2
I tried with sequence but it continues ranking to all students instead of getting reset at each student. Can any of you tried this please let me know.
You can use Numeric.sequence in tMap to achieve your goal.
Please take a look at my screenshots for details
Let us know if it is OK with you.