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

There are 30000 items in the original file. I have tried pivot tables and transpose but can't seem to get it to work.
Solved by C. L. in 21 mins
I want to write a formula that will update the summary tab using the 2 pivot tables.
Solved by O. E. in 29 mins
I am making pivot tables and it keeps giving me data from a different table, why?
Solved by G. E. in 12 mins
I want to create slicer groups by columns for pivot tables
Solved by C. J. in 14 mins
I have a data set where I have many duplicated student IDs (representing the same person) but each row gives me one column of unique information about them (which class they are taking that semester) but all other information (ie. demographics- race etc) is duplicated with the student ID. Therefore, when I go to make pivot tables (to see how many white students are taking AP courses for example) it can be misleading because each student may be represented more than one time (and how many times they are represented varies). What formula can I use to combine/match multiple rows of info into one row? So that each student will only have one row where all their course info is located?
Solved by C. C. in 30 mins
I'm trying to make a pie chart using data from a specific section of a pivot table. I've done this for 2 other pivot tables and created 14 charts for each, but suddenly when I try and select the specific data it just selects the entire pivot table!
Solved by C. Q. in 25 mins
I am trying to set up a vba series of code to have one of my slicers that have multiple connections to multiple pivot tables. I used this code to try and start from there but I have no clue how to do this: Sub Slicer() Dim ShF As Shape Dim ShM As Shape 'specify a slicer Application.ScreenUpdating = False Set ShF = ActiveSheet.Shapes("Slicer(1)") 'change position of the slicer With Windows(1).VisibleRange.Cells(1, 121) ShF.Top = .Top ShF.Left = .Left + 300 ShM.Top = .Top ShM.Left = .Left + 100 End With Application.ScreenUpdating = True End Sub
Solved by B. U. in 29 mins
I need help with pivot tables .......................
Solved by F. A. in 22 mins
Using the two pivot tables find the DealerIDs that were billed in BOTH months
Solved by E. U. in 29 mins
I need help fixing an error in one of my pivot tables?
Solved by M. J. in 26 mins