You need to add some formulas to the source code

http://www.contextures.com/xlPivot07.html#Unique


otherwise you can do this using advanced filter


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com




"STOFF" wrote in message
...
I am trying to count the number of drawings with errors. A drawing can
have
more than one error. I am using a pivot table to count but it will not
count
distinct records.