I have 3 tables, person, activity and a log of activities, with a line for each person and activity.

Please Login or Register  to view this content.
Using Excel 2013 and relationships I was able to count the number of persons by activity, month, gender, etc.
But I cant get the average of persons by activity/month and the number of distinct activities by date.

Any ideas? Thanks