Putting an order number (ranking) in a group (1 Viewer)

JM79

New member
Local time
Today, 00:38
Joined
Jul 11, 2006
Messages
7
Ok...

I have a report with 2 groups

Department
Employee

The detail in the report is numerous rows of overtime hours by employee. Its supressed and a summary (total) of the hours is put into the Employee group.

The Group Sort Expert has also been used to give the Top N (Top 5) Overtime employees descending so..

Tom 40 hours
John 38 hours
Dave 23 hours
etc..

I want to put an order number (ranking) for each employee so..

1. Tom
2. John
3. Dave

etc..

Any ideas ? TIA
 

Users who are viewing this thread

Top Bottom