Hello, I've created a pivot table and the pivot table has a unique identifier for each person in my table. Some people have one row in the table, some people have 10 rows in the table. I want to see how many total people I have in my pivot table, not how many rows (again, some people have multiple rows). I think that I need to find the "distinct value" for some reason that is what I keep thinking, but I'm not sure if that is the correct option. And if it is the correct option, that I need to count the number of distinct rows, how do I do that? Thank you in advance for your help!
Bookmarks