Numbering items in a report, including ties
Customers making qualifying purchases receive points based on the purchase.
Required: Report listing each customer with just the dates of the qualifying purchases and the number of points. The report should list the customer with the most points and descend to the customer with the fewest.
I have no problem generating this report. What I would like to do, though, is assign a ranking. Customer with the most points ranked 1 and so on down the line. Customers with tied points would get the same ranking. So the ranking could go 1,2,3,3,5 for example.
I've tried nine million ways to do this. I think you are hiding the 9.000.001st way, which is the one I am looking for.
Won't you please share?