Sales Ranking in Crystal

[Gragi]

Hi Gurus,
I'm using Crystal9 and database is Informix
so in my report I need to give some ranks on some totalsales order by names

Sample Data

Prod TotalSales
AA 12,340
BB 15,500
CC 5,450
DD 10,895
EE 3,200
FF 20,789

I need the report like
Prod TotalSales Rank
AA 12,340 3
BB 15,500 2
CC 5,450 5
DD 10,895 4
EE 3,200 6
FF 20,789 1

Can anybody give me immediate solution.

Thank You,
Gragi

 

[lbass]

Please see thread1007711.

-LB