I have some data that I'm trying to figure out if this is even possible to accomplish with a pivot table. I've simplified the sample to hopefully be able to demonstrate what I'm hoping to do. So I have a list of sales and in some cases there are two officers responsible for the sale. So what I'd like to know is the number of prospects (this would be a duplicated total) and then the total of the sales (this would be the de-duplicate total). Is that possible to do utilizing one sheet of data pulled into one pivot table? In the past I've just been making a copy of the sheet and removing the duplicates that gives me the total sales, and then my other sheet gives me the total number of visits but I'm wondering if there is a way to accomplish this using one set of figures. Thanks so much for any help provided.
So In my example below the numbers I would like to see are 10 Prospects (each sales person went on 1 visit with each prospect) and $130 in sales
So In my example below the numbers I would like to see are 10 Prospects (each sales person went on 1 visit with each prospect) and $130 in sales