Hello everybody,
I have read the last posts on counting issues in pivot tables but I have found no clue for my trouble.
I'm using a "Count of xxxx" in a pivot table and it is counting the number of records of this column or category.
What should I use if I want to count the number of distinct records??
I cannot find such an option.
I am using Excel 2000.
Thank you in advance for your help,
Ludovic
I have read the last posts on counting issues in pivot tables but I have found no clue for my trouble.
I'm using a "Count of xxxx" in a pivot table and it is counting the number of records of this column or category.
What should I use if I want to count the number of distinct records??
I cannot find such an option.
I am using Excel 2000.
Thank you in advance for your help,
Ludovic