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 have a workbook with multiple sheets each containing pivot tables. I need to summarize the totals for each description/model number on a new sheet.
Solved by O. L. in 22 mins
I need to summarize data from pivot tables on different sheets within a workbook.
Solved by K. D. in 20 mins
I need to combine data from multiple pivot tables.
Solved by S. S. in 19 mins
I need help with some graph I created from a pivot table
Solved by O. B. in 18 mins
I am trying to group all similar items in a pivot table.
Solved by E. E. in 26 mins
I have a spreadsheet that lists session numbers in one column A, trainer in column B and date in column C and participant in column D. I need to be able to find out how many different sessions each trainer did, the average number of participants per trainer, the total number of participants per trainer and also by date. When i do a pivot table it gives me total number of participants for trainer but i can't get the number of sessions, have tried subtotals but not getting it
Solved by K. D. in 24 mins
Hi I was given a Excel file of tabular data with multiple column headings. I was to create a Pivot Table with a percent frequency. When I select the data column to create a pivot table I will need to group the left column(sales range) of a two column pivot table. The right column has the percent frequency of sales. How can I make the groups like this: 0-24.99, 25-49.99, 50-74.99, 75-99.99 etc.. Its not letting me for some reason
Solved by X. H. in 27 mins
I am trying to identify the change with in two tabs 8.1.18 and 9.1.18 I would like to see this in a pivot table and identify these change factors.... Booked upsell Close Date Change
Solved by B. C. in 24 mins
So I have monthly data - I would like to build a pivot table that combines each account name and show if the data change from month to month in a pivot view table look Compare field needed and highlighted if the data changed from month to month Stage change Booked upsell change Close date change
Solved by B. A. in 12 mins
I created a pivot table and am trying create a calculated value field.
Solved by F. A. in 22 mins