I have a table widget in reporting services where I group rows on a given id.
For each group, I display the number of rows per group, using countrows().
How can I display the average number of rows per group at the end of my report ?
What I am missing is : how to count the number of groups?
Best Answer
This is from memory - not sure if this expression is correct:
Assuming that the "ID" you're grouping by is a single field, that sort of expression should get you what you want.