AnsweredAssumed Answered

Numbering items in a report, including ties

Question asked by rgnant_1 on Feb 17, 2011
Latest reply on Feb 18, 2011 by rgnant_1

Title

Numbering items in a report, including ties

Post

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?

Thanks.

Outcomes