Thanks for the response (and all your great responses, by the way!) I thought about doing some summary fields, but I'd like to be able to quickly answer questions about different time periods as well. (E.g., how many PTs last week, last month, or December of last year, in fiscal year 2017, etc.) Also, different resource specialists may actually help the same person.
I'm wondering if I should just say this can't be done in the activity reporting by resource specialist and seperate volume reports and patient reports. Then if I created some summary fields that wrote up the number of associated activities filtered on a certain month or year I could at least give the number of unique patients helped in those defined time frames from the patient table.
It seems a little puzzling there is no native ability to do a distinct count as a calculated column or something. The fact that you can see the number of groups in a report that groups by a field (like patient record ID in this case) makes it seem to me that the data is being calculated in QB somewhere. Oh well. Maybe in a future release.