Forum Discussion

Ubaid ur Rahman's avatar
Ubaid ur Rahman
Brass Contributor
Oct 20, 2018
Solved

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...
  • SergeiBaklan's avatar
    Oct 20, 2018

    Hi Ubaid,

     

    Creating Pivot Table add data to data model

    and in field settings select Distinct Count

    Result as attached

Resources