How do I set up Distinct Count in a Pivot Table?

[STOFF]

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.

 

[Peo Sjoblom]

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