I am having a problem trying to get a report to work as I want it.
I have a table of Groups and a table of Sessions. A Client is a member of a Group and they attend Group sessions.
I have created a report based on the Sessions table which breaks by GroupID and Client ID which shows each Client and their total number of sessions. e.g.
Group A Total Session 15
This works fine. But I also want to show how many individual clients attended these sessions. In the above example it would be 3 but I can't seem to figure it out.
Any suggestions anyone?