You can use RunningValue function as the text value of the line number column.
If you want a numbering for rows within a dataset, you can use
=RunningValue(1, SUM, "Employees")where Employees is the dataset name.
If you have groups in your reports, say one of the groups has a name "EmployeesByCity", then you can replace the last part of the RunningValue with this group name shown as below
=RunningValue(1, SUM, "EmployeesByCity")
You can check the below link for a sample
I've got a similar issue that RunningValue won't work for. Basically, what the business users want is a line number for each line in the report. Independant of the groupings. I believe this has to be done during the rendering of the report as it has to cross groups after all the report processing has been done. Here's a small sample of what they want it to look like.
Column A Column B Column C
1 Group 1 Header
2 Group 2 Header
6 Group 2 Footer
7 Group 1 Footer
The count can reset at the begging of each page, or continue, doesn't really matter. I'm trying everything I can think of.
Any ideas out there?