CiviCRM Community Forums (archive)

We're trying to create a report that will show us all the activities for a quarter. Activities include such things as:

    visits by nurse
    getting a ride to the doctor
    attending exercise class
    in-home assessments

We've put these items in "Activity" records for individual contacts.
For most activities, the report needs to show a total number of individuals served for each activity.  That means, that if an individual gets two rides in the time period, they are only counted once for that activity.

Example:
Bob had 1 nurse visit, 2 rides, attended 2 exercise classes, and had 2 in-home assessments
Jane had 2 nurse visits, 1 ride, and 1 exercise class, no assessments
Doris did not see the nurse, had 2 rides, and attended 1 exercise class, no assessments

Our report should show:
2 people received nurse visits, 3 people received rides, 3 exercise class attendees, 1 person received assessments

It's easy enough to get total activity (3 nurse, 5 rides, 4 exercise attendees, 2 assessments), but we can't figure out how to show number of individuals served for each activity.  Any help would be appreciated.