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

create a powerpivot "many-to-many" relationships for pivot table output
Solved by O. U. in 22 mins
One column has lease expiry dates, I only want to include data from leases that are greater than a certain time period in a pivot table, can I do that?
Solved by O. A. in 29 mins
I need detailed excel pivot table tutorial.Can you help me with some detailed notes.
Solved by K. W. in 13 mins
Hi I need help in setting up a pivot table
Solved by G. U. in 30 mins
pivot from another dynamic pivot table(alt+d+p), but the source pivot must be dynamic range
Solved by S. D. in 11 mins
i have three worksheets, year 1, year 2 year 3 in once excel file and need to be able to search these three sheets for various content and do analysis on the data, all three sheets are set up exactly the same, can you help me create pivot tables or whatever you think is best
Solved by I. J. in 30 mins
I need to figure out how to add a calculated column in a pivot table that would divide one cell in each row by the total of that row, and update accordingly, that is, be part of the pivot table
Solved by D. Y. in 28 mins
Hi there, I want to plot a graph from a weekly data. The problem is some of the months there are just two weeks data. - I want to present my data in columns to indicate the data loss - I am guessing I need to use pivot table? But I am not sure
Solved by K. B. in 11 mins
Need Pivot Table help. I have information such as: Name1 | Date1 Size | Name2 | Date2 Size Apple | 5% | Apple | 7% Microsoft | 6% | Microsoft 4% Google | 3% | Google | 0% Facebook | 0% | Facebook | 1% I want to create a table which lists all of the company names in 1 column (i.e. aggregates all Name1 and Name2's and puts them into 1 column) and then has each subsequent Column containing the corresponding size to that date. So it would look like: All names | Date1 size | Date2 size
Solved by A. A. in 26 mins
I'm trying to create a Pivot table from multiple tables but I don't see the option box that allows me to choose to analyze multiple tables. Where can it be?
Solved by B. H. in 21 mins