Pivot table- not getting desired results

Hey guys, need some help.
I have a base with 3 tables: Companies, Contacts and Engagements, where the engagement types(meeting, email reply, etc) are listed per contact and each company has more than one contact. I’ve done a pivot table crossing engagement type x Companies info but the number showed is the engagement per contact not per company.
For example, 2 contacts of the same company participated in the same meeting, in the pivot table I need to show the number “1” because its only one meeting for that company, however, it’s showing number “2” because there are 2 contacts related to the “meeting” engagement. How to solve this?
;

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.