Get instant live 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 am trying to group in a pivot table columns and sub columns, id like to see the piviot table columns the same as how the monthly tabs show an "extended travel" column with sub columns with "mileage" "meals" "hotel"
Solved by I. H. in 21 mins
I have two value field columns in a pivot chart and I need to calculate a third column (percentage). Column A/Column B *100 I can't figure out how to do that outside of copying the values to a normal sheet and doing it manually. I would like to do it within the pivot table so the values update as the data changes. I have tried calculated fields and I can't get it to work.
Solved by T. U. in 27 mins
what is pivot table? do you have any way to explain it simply?
Solved by F. C. in 22 mins
I need a formula where I can use a pivot table/chart and it will sort and count my data. What I want is to count the # of times a certain state appears in my data and then sort that into the 4 main regions of the country
Solved by M. Q. in 15 mins
I need to evolve a spreadsheet to include a new line item. It is a muti tab google sheet that is relatively complex and includes a pivot table on a summary page
Solved by B. E. in 29 mins
How to filter pivot table to show monthly data across years - i.e.: Oct 17 Nov 17 Dec 17 Jan 18 Feb 18 Mar 18
Solved by G. Y. in 15 mins
Needing assistance with creating a unique list of values from across multiple columns. I worked with someone the other night, but the solution they gave me did not work. I was shown to use a pivot table. I would rather use a formula/function to accomplish this.
Solved by K. L. in 26 mins
How can i create a pivot table with all basics of pivot table
Solved by O. C. in 25 mins
I need help with pivot table in excel with example
Solved by A. Y. in 25 mins
Within a pivot table, I wont to only reflect data that has "competitor" in the name of the Campaign Name value. How do I do that in Excel for Mac 2016
Solved by M. U. in 13 mins