How to Count Unique Values within a Pivot Table?

Copper Contributor

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