Counting distinct values across columns

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?

Originally Posted by Pepe Le Mokko

Administrative note

Welcome to the forum

in your haste to solve your problem, you probably missed the yellow banner advising how to get answers faster by posting a sheet ?

Please take a moment to read it and attach a sheet accordingly.

Thanks you for helping us help you

Thanks, but I'm afraid this is a work-related issue and it isn't possible/allowed to circulate company data.

2 Ways to Calculate Distinct Count with Pivot Tables

https://www.youtube.com/watch?v=NV3w...xcelCampus-Jon

Thanks... I watched the video, but it doesn't seem to apply to this situation. I guess what I'm trying to count are distinct permutations of values within "client" and "event name" columns.

Without files it is not possible to answer.