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. |
How do I set up Distinct Count in a Pivot Table?
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. |
All times are GMT +1. The time now is 05:59 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com