Results 1 to 2 of 2

Duplicate Report Filter and Row Labels Filter Across Multiple Pivot Tables

Threaded View

  1. #1
    Registered User
    Join Date
    02-15-2013
    Location
    Florida
    MS-Off Ver
    Excel 2010
    Posts
    2

    Red face Duplicate Report Filter and Row Labels Filter Across Multiple Pivot Tables

    Hi - Looking for some help on the following:
    I have 3 pivot tables on one sheet sourcing from the same data set. I have the same Report Filter (Month/YR) on each Pivot table and the same Row Labels item as well (Material Numbers). I would like to select single values on Report Filter and multiple values on the Row Labels on the first Pivot table, and would like the same selections shown on the other two pivot tables. I have read a few posts and tried some of the code but when i applied a filter on the first pivot table, the filters did not change on the second and third pivot tables.

    Sample of sheet for easier reference Sample Tables - Updated 02 15 13.xlsx


    http://www.excelforum.com/excel-gene...-criteria.html

    http://www.excelforum.com/excel-gene...ot-tables.html

    Private Sub Worksheet_Change(ByVal Target As Range)
        If Not Target.Address = Range("B2").Address Then Exit Sub
        Dim PT As PivotTable
        Dim ptItem As PivotItem
        On Error Resume Next
        For Each PT In Worksheets("Sheet1").PivotTables
            With PT.PivotFields("MyReportField")
                If .EnableMultiplePageItems = True Then
                    .ClearAllFilters
                End If
                Set ptItem = .PivotItems(Target.Value)
                If Not ptItem Is Nothing Then
                    .CurrentPage = Target.Value
                End If
            End With
        Next
    End Sub
    Last edited by tash; 02-15-2013 at 05:43 PM. Reason: Inlcuding attachment

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1