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

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.

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" <[email protected]> wrote in message
news:[email protected]...
>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.