A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Counting Values
I am trying to figure out how many of our customers have used our company for more than 1 job type, we have 3. I have a Pivot Table that has all customers and how many of each job type they have used over the past two years. The problem is if they used us for one job type 8 times in the past two years, it totals as 8, when I want it to total 1, because they have used us for 1 job type 8 times. How do I create a table that is measuring the number of job types they have used us for, not how many jobs we completed per job type.
Microsoft 365 and Office | Excel | For business | Windows
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.