SOLVED

How to count unique names in Pivot table?

Brass Contributor

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 function I saw in pivot which can count like what i want.

 

Help me out please.

 

Thanks in advance!

 

 

4 Replies
best response confirmed by Ubaid ur Rahman (Brass Contributor)
Solution

Hi Ubaid,

 

Creating Pivot Table add data to data model

image.png

and in field settings select Distinct Count

image.png

Result as attached

Thanks alot!
Thank you Detlef!
1 best response

Accepted Solutions
best response confirmed by Ubaid ur Rahman (Brass Contributor)
Solution

Hi Ubaid,

 

Creating Pivot Table add data to data model

image.png

and in field settings select Distinct Count

image.png

Result as attached

View solution in original post