PIVOT - Duplicate Values

[jfeagle]

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

 

[sandy666]

post link to an example of representative source data and expected result in shared Excel file. use OneDrive, GoogleDrive or any similar.

 

[jfeagle]

Lets see if this works, Book2.xlsx

 

[sandy666]

and expected result

you didn't read this part

 

[sandy666]

maybe but I am not sure what you really want to achieve

 

[jfeagle]

Thanks for your attempted help, In my original message I put what I was hoping to expect as the results...

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

 

[sandy666]

could you show end result (manually created)?