AnsweredAssumed Answered

SubSummary problem

Question asked by 0614775139 on Mar 13, 2014
Latest reply on Mar 19, 2014 by 0614775139

Title

SubSummary problem

Post

     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

             John     3

             Mary     5

             Peter    7

     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?

Outcomes