Sorry about the shortage of information! In a mediation several students meet to resolve the problem. Each student belongs to a school "family". Often students from different families mediate together. Two files support the system.
The event log records info about the nature of the conflict (eventID, date, category, referring person, description, etc.). The event log relates to the participant log (by eventID) which stores the attributes of each participant (id, name, grade, ethnic, school family etc.).
I am reporting participant counts from the participant file and want to report monthly the total number of students in each family who mediated (participants) and the number of actual students. In a typical month a family might have 15 participants (occurrences) involving only 10 students (a few repeaters). If Susie mediated 3 times, she would count 3 times as a participant but only once as an individual.
I would like to organize the report by month with each line within the month showing: school family name, participantCount, individualCount
I hope this helps clarify.