I am trying to do some pivot table analysis from output generated from a CRM system that relates to a few hundred client events hosted by a company.

For some reason, the system will generate a replicated row of data attributed to each employee that attended the events (e.g. if 20 clients participated and 5 employees were present, there are 100 rows). I am trying to summarize the number of distinct customers that attended events - how can I achieve this?

Doing a distinct count on the event name just results in the number of events. How can I count unique client-event occurences?