Forum Discussion
Ubaid ur Rahman
Oct 20, 2018Brass Contributor
How to count unique names in Pivot table?
I have attached the document for explaination what I want. I have names per Branch and I want to count only unique persons in Pivot table. (in Pivot is must). There is no standard counting fu...
- Oct 20, 2018
Hi Ubaid,
Creating Pivot Table add data to data model
and in field settings select Distinct Count
Result as attached
SergeiBaklan
Oct 20, 2018Diamond Contributor
Hi Ubaid,
Creating Pivot Table add data to data model
and in field settings select Distinct Count
Result as attached
Ubaid ur Rahman
Oct 21, 2018Brass Contributor
Thanks alot!