In Microsoft Excel pivot tables, how can I count only unique values?
I want to count only unique values in a pivot table count field setting, not count all entries. This is analagous to Unique Values Yes setting in an Access query.
ive never used Access
so im guessing what you want here
-drag your field into the Data section
-it should default as a count of
- if not, then right click on your data column
- click field settings
- change it to count of
February 19th, 2010 at 5:54 pm
ive never used Access
so im guessing what you want here
-drag your field into the Data section
-it should default as a count of
- if not, then right click on your data column
- click field settings
- change it to count of
References :