Pivot filter and slicer combo

[ngh007]

Hello,

Im trying to create multiple pivot tables which synchronize on the same filters. I also have slicers which are linked to all the pivots. The problem is that while the slicers work synchronously with the pivots, the filters only seem to impact the ONLY one table at a time.

Im trying to find a way such that:
either the filters are connected across tables
Or the slicers connect to the filters

Ive been looking online for so long and all results I found talk about slicers and avoid filters - I need both.

Im using Excel 2010.

Thank you!

 

[Worf]

Hello and welcome to the Board


You could use VBA code attached to a button; clicking it would apply filters across all tables, as the example below does:

Sub Filter_All()
' Excel 2013
Dim ws As Worksheet, pt As PivotTable, mpf As PivotField
Set ws = ActiveSheet
MsgBox ws.PivotTables.Count & " tables at " & ws.Name
For Each pt In ws.PivotTables
    Set mpf = pt.PivotFields("GROUP")
    If pt.Name = "PivotTable2" Then Set mpf = pt.PivotFields("Status")
    mpf.PivotFilters.Add2 xlValueEquals, pt.PivotFields("Count of Stat"), 2
Next
End Sub