Group number with multiple groups

[er123]

I have a report that has two groups. I would like to get the total number of groups in Group 2 under each group of Group 1. I know there is a Group Number field in the special fields but that will only give me the group number of Group 2 for the whole report. To clarify assuming Group 1=A and Group 2=B:
A-1
B-1
B-2
B-3
A-2
B-1
B-2

 

[hilfy]

You could probably do this using a Running Total. Set it do to a distinct count of the Group 2 key field and reset to 0 when Group 1 changes.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.