Forum Discussion
How to Count Unique Values within a Pivot Table?
In a pivot table (attached), I would like to add a column to show a count of unique names. Effectively for a small batch with only one territory, it is easy to do a =COUNTA for the names listed. But how can I do this for multiple names in multiple territories within a pivot table? (~20,000 lines to analyze)
Pivot Setup:
Territory (Country1) is in Rows
Name (Aaron, Adrian, etc) is in Rows
Count (5,3, etc) is in Values
Thank you!
Jim
1 Reply
JimS0422 , if creating PivotTable you select the option Add data to data model, in list of aggregations for values you may select Distinct count instead of Count
