Get instant live Excel expert help with Pivot Tables

“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'm having trouble setting up my pivot table. I'll send the documents and what I need. Can you teach me how to get that information from the pivot table?
Solved by D. U. in 12 mins
Need data analysis (pivot tables?) on 100 customer service agents in 4 different locations with different variables.
Solved by V. S. in 29 mins
I need to make a pivot table on another sheet that will take all of the same part numbers, add the QTY fields of the same part numbers together and give a grand total of how many parts there are across the whole worksheet.
Solved by C. C. in 26 mins
I need to know how to why cell Y3 in the pivot table on the Data tab does not update and how I can update it so it registers '10'
Solved by M. U. in 21 mins
I need to take two spreadsheets and create a Pivot Table to aggregate contacts by company name, have a second column that shows a total number of contacts for each company, then be able to rank them from largest to smallest. Can you help me with rank function in table?
Solved by A. H. in 14 mins
i need to calculate few thing in my pivot table, but i don't want to chance every time my formulas whet pivot table getting more columns because of new data
Solved by M. W. in 25 mins
1. I have some conditional formatting rules set for the pivot table“Cycle Time”. Whenever the pivot table auto refreshes the conditional formatting is lost. Applying rule to entire column doesn’t work and the formula changes on its own. 2. On the sheet named “Individual Rep Productivity” filtered cells have been marked “remove blanks” under the drop down in A1. Formulas on this sheet pull from other sheets. Blank cells that are filled and later times and will populate. I would like for this to automatically update without having to check the box next to blanks and then uncheck it again for the new data to show up.
Solved by O. Y. in 22 mins
Please use the spreadsheet entitled Data, and pivot the information to complete the table headed “Indicator”. The two charts currently show September’s data, so please update them with the relevant figures for October. Then use the space at the bottom of the page to provide Chertsey Zoo with commentary and insight. someone on here has managed to get the table indicator filled, but now need to put the pivot table data for October's month into a chart,
Solved by I. F. in 19 mins
on the 'Data' sheet, there is a Pivot table that commences on cell AC4. For the Row 4, I need the numbers to be in numerical order from 0-11 and the cell that is AQ4 that currently reads 'blank' removed. Can you help?
Solved by O. Q. in 30 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