Get instant live expert help on I need help with advanced pivot table excel 2010
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”
Here are some problems that our users have asked and received explanations on
I need help on advanced pivot table functions
Solved by M. W. in 23 mins
Hi, pivot tables in excel 2010, able to show paid vs. pending to date, but would like to insert column of this up to last month (06/30).
Solved by D. H. in 30 mins
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 excel count distinct in the field value settings. Can you help?
Solved by S. Q. in 22 mins
I am creating a pivot table from a large excel spread sheet and rows are missing in the pivot table
Solved by S. H. in 20 mins
Run an advanced filter on the table data set using the criteria range A1:J2. on celldata sheet
Solved by M. W. in 19 mins