MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Pivot Tables and the Count of Field

Posted by Richard Jones on October 19, 2000 1:16 AM


I summarise my data using a pivot table to see what each salesman has sold breaking down into type of sale.

I also need to know how many customers he has sold to in any given period.

When i try an extra field below the value i.e. Count of customer name, it treats all repeats as an individual customer.

Is there a way that it will only count unique entries.



Posted by Richie on October 20, 2000 12:35 AM

Looks like i missed the boat

If anyone could help me with this it would certainly improve my day!!

Posted by thomas venn on October 20, 2000 1:27 PM

try this... not elegent, but it may work. input 1 (one) in a column next to the customer name (if there is a customer name, put 1 in the cell of the adjacent column). name the column "cn count one", then in your pivot table, instead of count "customer name", do a sum "cn count one".