Oct 20 2018 03:54 AM
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!
Oct 20 2018 04:45 AM
SolutionHi Ubaid,
Creating Pivot Table add data to data model
and in field settings select Distinct Count
Result as attached
Oct 20 2018 04:49 AM
Oct 20 2018 04:45 AM
SolutionHi Ubaid,
Creating Pivot Table add data to data model
and in field settings select Distinct Count
Result as attached