I have a sorted found set. Now I want to rank this set from 1 to last.
I looked it up and came across this website for identifying unique records and then ranking entries in a subsummary report, here is the link:
So in order to rank in their method, you have to create a field called flag_unique whose unstored calculation looks like this:
(I'm trying to rank the Product Types)