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!”
Here are some problems that our users have asked and received explanations on
I have a large pivot table of customers, I need to sum when there are new customers and in reverse, when customers leave. Not sure if this can be done through pivot table. I just can't figure out the best way to do this with a sumif formula
Solved by X. S. in 17 mins
Need to update several pivot tables in a worksheet after the data is updated (data is a OBDC query)
Solved by T. B. in 28 mins
I have a sheet with transaction for a month. Each month I get a new transaction sheet. I need a pivot table to calculate the total transactions for each day. However, before that, I need VBA/Macros to add in the date next to the qty sold, it is currently placed next to the receipt#.
Solved by C. Q. in 24 mins
I need a pivot table sample data
Solved by Z. W. in 22 mins
I need to figure out how this pivot table was created so that I can apply it to other sheets
Solved by B. Y. in 21 mins
I'd like to setup a pivot table to show information from column C, D and I
Solved by S. H. in 26 mins
Hi, I have multiple worksheets in my spreadsheet. I want to create a single Pivot table for all worksheets. Please help me with this.
Solved by X. W. in 12 mins
hi, how can i create pivot table actions at google sheets?
Solved by B. C. in 11 mins
my Pivot table is not picking up data that i have added in months ago. it is suddenly now not picking it up. please help
Solved by C. C. in 21 mins
Hi, I'm looking to create a pivot table but am not sure what to include in it. It's a whole list of questions which are connected to each other and am now at the pivot table section
Solved by S. H. in 25 mins