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!”
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