I've created a Report Services report (SQL 2005) that is a list of personnel:

-----------------------------------------------
LASTNAME       FIRST NAME    MEMBERSHIPGROUP
-----------------------------------------------
JAMES           JOHN            DENTAL
THOMAS          ALFEY           DENTAL

KELLY           DUMBO           MEDICAL
SMITH           JODI            MEDICAL

The report is group by MembershipGroup (Grouping/Sorting = table1_group1). I want to have in the group footer how many people are listed in each group. Anyone know the steps to do this? I've tried creating a calculated field in the report, but I just can't seem to figure it out.

Thanks

Kirk