Count Unique (Distinct) Items in Excel Pivot Table
Count Unique (Distinct) Items in Excel Pivot Table
How to count unique items (distinct count) in a Microsoft Excel pivot table. For example, if you're analyzing sales data, you might have questions such as:
--How many unique products were sold in each store?
--How many unique salespeople sold each product per region?
This method works in Excel 2013 and later versions.
To get the sample file, and to see other ways to get a pivot table distinct count, go my Contextures website:
https://www.contextures.com/pivottabl...
Instructor: Debra Dalgleish, Contextures Inc.
More Excel Tips and Tutorials: http://www.contextures.com/tiptech.html
Subscribe to Contextures YouTube: https://www.youtube.com/user/contextu...
#ContexturesExcelTips