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 need to solve one task with requires using Pivot Tables
Solved by A. W. in 26 mins
I am using google sheets for the same time and need to create a master pivot table that links multiple tabs data by Project Resource role and total day but not sure where and how to start
Solved by T. A. in 16 mins
I have one datasource with 2 separate pivot tables and one slicer giving the year and month. I would like to click on one date option in the slicer and info displayed should be current month on one pivot and previous month on the other pivot. Is this possible
Solved by V. J. in 14 mins
Pivot table is not showinh all columns form the datya field when it is created
Solved by A. F. in 30 mins
I would like some help in copying values from a pivot table. See 'Data' sheet, I am trying to copy the values from the pivot table in rows J - U, to the table in rows w - AH.
Solved by T. Q. in 16 mins
When I change the color of font in my table, I want it to update the color font in my pivot table. What are the settings to do this?
Solved by V. C. in 28 mins
In a field within my database, there should be only one value. For maintenance purposes, I want to find those multi value fields and update to the correct, one value. When using Excel 2010 to search for those multi values within my database field, is it possible to sort the pivot table by the number of occurrences within the record instead of the number of rows for each record? Please let me know if there is a more logical approach to obtain the information; i.e., sort spreadsheet instead of pivot the spreadsheet.
Solved by X. L. in 20 mins
I need help with creating a pivot table that shows name even it has no data
Solved by D. H. in 27 mins
I have a spreadsheet with a pivot table that includes my data. It's broken up by monthly dates, feedback received on a 1-4 scale, and also %'s. I want to build graphs to depict those. As well as build a trend graph showing an icrease or decrease in responses over time.
Solved by D. W. in 29 mins
i have created a pivot table to analyse the data from sales worksheet, may i know is it correct? and can u recommend me what other data can i analyse and create pivot table
Solved by I. B. in 11 mins