Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to rank 2 separate fields in my script. the first field is ranked perfectly, but the 2nd field is not starting at 1 like expected. Its stating where the previous rank left off:
Thanks for the quick reply, but let me provide a few more details, as your suggestion did not work.
The result set has 7 unique Segments, and I am trying to rank the Outstanding amount for all past due customers from 1 to N within each segment. So each segment (7 of them) should have a ranking from 1-n. Additionally, I am trying to rank the watchlist customers by outstanding amount within each segment. So, two sets of rankings, both ranked by outstanding amount, one for past due customers and one ranking for watchlist customers.
The first ranking works with no problem. Then 2nd ranking (using basically the exact logic) does not restart the ranking at 1.