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
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