Get instant live expert help on I need help with distinct count in pivot table excel 2010

“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you’ll get expert help in seconds.

Our professional experts are available now. Your privacy is guaranteed.

Here are some problems that our users have asked and received explanations on

I have a pivot table of Server names that are duplicated down a list of database /table names. Total count is >500 but I want to show the distinct count in the pivot, which is closer to 90. I'm in 2010. I've tried inserting a formula =counta(), but it isn't working and 2010 does not have Distinct Count in the field value settings. Can you help?
Solved by S. Q. in 22 mins
Distinct count, unique values in pivot tables
Solved by G. U. in 19 mins
I need pivot table help, inserting a calculated field, using distinct counts
Solved by B. B. in 26 mins
hi there is no count distinct at my excel
Solved by K. E. in 29 mins
I have a problem regarding to How to Count Unique and Distinct Values in Excel
Solved by S. J. in 20 mins