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. Bu...
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