Customer's Sales Postion

[Housey]

I have created a report showing customers and their sales for the last year. I now need to create a formula that works out what position they finished, like this;

Customer | Sales | Position
---------------------------
AAA | 100 | 2
BBB | 50 | 5
CCC | 80 | 3
DDD | 125 | 1
EEE | 75 | 4

It is important that the customers are in alpha order.

How do I get Crystal Reports (8.5) to work out the sales position?

Thanks

 

[lbass]

Please see thread767-951908. If your sales field is a database field, not a summary and you don't have many rows, you could use the NthLargest method. Otherwise, try the subreport method that I outlined in that thread.

-LB