Changing Pivot Table Selectors

Master82 · #1 (**permalink**) 07-21-04, 09:59

I have two pivot tables, both contain the same selectors (Department & Team Manager) which will enable you to drill down. [ie view only the values for the selected departments]

How if selecting a department in the first pivot table can I get the second pivot table to select the same department (same for team Manager too)?

Basicall so I dont have to select the required department/Team Manager twice!

Please help if you have a solution, maybe a drop down box that controls the pivot tables or something? VB code? Anything!

shades · #2 (**permalink**) 07-22-04, 11:01

You could use VBA and set it up to link to an Option button on the worksheet. For instance, this code would allow you to change from monthly view to quarterly view of same data. You could add more lines to adjust the other pivot table, or you could have two option buttons one for each pivot table, and that way your double selection would be in one area.

Code:

Private Sub OptionButton1_Click()
'   Months only
    Application.ScreenUpdating = False
    With ActiveSheet.PivotTables(1).PivotFields("Month")
        .PivotItems("Jan").Visible = True
        .PivotItems("Feb").Visible = True
        .PivotItems("Mar").Visible = True
        .PivotItems("Q1").Visible = False
 
    End With
End Sub

At least this might point you in the right direction.

Internet Services

Web Development

Digital Marketing

Consumer Tech