I'm working on a dataset using pivot table. I would like to count unique text values only in a column, unfortunately, pivot table's count function would count all identical text values as well. May I know how will I be able to use pivot table to count unique text values only?
For eg:
Company...