That's it! Thanks!
On Fri, Apr 3, 2020 at 3:34 PM Andy Sayer <andysayer@xxxxxxxxx> wrote:
It sounds like you’re after plain old row_number.
Thanks,
Andrew
On Fri, 3 Apr 2020 at 21:33, Ethan Post <post.ethan@xxxxxxxxx> wrote:
I have a data set with groups of 40 rows. I need to rank 1-40 in each set
for charting order by amount. In some cases amounts are all the same or
some are. I still need to order 1-40 without any skips or duplicates. I can
write a process that does this but thought there was a function for it.
Rank and Dense Rank don't work because you get duplicate ranks when amount
is the same. Maybe doesn't exist. Just checking.
Thanks,
Ethan Post
FarmPulse360.com