Mar 28 2019 03:57 PM
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
Mar 29 2019 01:19 AM
@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