Pivot tables have always had a major problem- when you try to count
unique records, it will give you the total number of records.
Example:
say you have a database of service records, including service provider
name and state. If you wanted to determine how many service providers
are in a particular state, a pivot table would instead give you the
total number of records for that state, even if you had service provider
set as a count.
Until now!
Starting with Excel 2013, there's a workaround to get the actual unique value count.
http://datapigtechnologies.com/blog/index.php/distinct-count-in-pivot-tables-finally-in-excel-2013/
Search terms and phrases:
Unique count pivot table Excel
Distinct count pivot table
No comments:
Post a Comment