Linking Different Pivot Tables with One slicer

[cmajka]

Hi All -

Having a tough time finding a solution for this one. I have 8 tables loaded into the PP data model. From each of those tables, I have created a pivot in Excel. I would like to insert a slicer that would effect all 8 pivots if, for example, the user selected the field 'State' on the slicer. I thought i would be able to accomplish this in Report Connections, but it doesn't seem to change the formulas that are pointing to those pivots. Thanks

Chris

 

[ImkeF]

Is my guess right that you meant "Filter Connections" and not "Report Connection"?

If the filter-Settings don't affect the numbers in your Pivot table this could be due to the fact that your tables in the PP model are not connected to each other in the right way (or at all?)