Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2004
    Location
    North West England
    Posts
    2

    Arrow Unanswered: Changing Pivot Table Selectors

    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!

  2. #2
    Join Date
    Oct 2003
    Posts
    1,091
    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.
    old, slow, and confused
    but at least I'm inconsistent!

    Rich
    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •