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 question for sorting a set of data by using pivot table and calculations: In patients that were switched to med B, what percent of the 2nd med B dose (total dose in month following the 1st dose) was the same as the 1st med B doese? Higher than the 1st dose? Lower than the first dose (but not a zero dose)? No dose at all(a zero dose)? (calculate for patients switched in Sep only, Oct only, and Sep and Oct together, assume Med B dose is for 1 month only)
Solved by Z. A. in 14 mins
I need a formula that will give me the days between 2 dates for data in a pivot table I have, however if a row only contains a date in one of the two columns I need it to display nothing in the output column, right now it displays a long negative number.
Solved by E. B. in 27 mins
I have a pivot data in excel which shows count of job requests and count of completed jobs. I would like to have a running count of jobs on the go.
Solved by D. F. in 28 mins
Challenging problem (details upon request): in a pivot table, compare the first two values according to different criteria (equal, less than, or larger than, or equals to zero)
Solved by K. D. in 29 mins
Hello. I am hoping to be able to copy down formula from a pivot table, into another pivot table, But when I copy down, it seems to remain as a fixed reference.
Solved by A. F. in 13 mins
I need pivot table help. I have used pivot tables for years - I am on a different computer and the insert tab does not give a pivot table option. I have checked that no fields are missing. I'm on a MacBook.
Solved by M. H. in 26 mins
I need help creating a collapse/expand macro button on a pivot table example data. Need to figure out how to recreate the pivot table
Solved by Z. U. in 25 mins
I am trying to create a pivot table from data in multiple tables. All the tables have the same headings and are formatted the same but each table represents a different company. I'm trying to create a pivot table that draws the data from all company tables to allow us to report results by office location for each company.
Solved by M. A. in 25 mins
I need help creating a pivot table. I do not know how to start.
Solved by F. J. in 14 mins
Hello, I am looking to create a pivot table that will summarize the data into a grid and place the data under the correct columns. The columns must remain static. The paygrid tab with items highlighted in columns need to remain static but we will have changes to employees week to week. We pull the information based on employee number using the export tab.
Solved by F. F. in 17 mins