This content has been marked as final. Show 1 reply
Comment posted a "sum the reciprocal" method that can work for this. I wouldn't say it's super simple, but it works.
- Define a summary field, sSessions, as the "count of" your client ID field. By itself, this gives you your "8 sessions".
- Define a calculation field cFraction, as 1 / GetSummary ( sSessions ; ClientID )
- Define a summary field sClientCount as the "total of" cFraction. This last field will give you your "2 clients" when you sort your records by ClientID, (The "break field" in the getsummary function and place this field in your trailing grand summary layout part.