Reporting connections on Slicers

[Sweedler]

Hello

So I have a, somewhat large document, to track several different aspects of my financials. That being the case I have several tabs, each of which include a table. I have a separate tab, dashboard, that summarize those tables for me.

Now Ideally I would just have entered a Slicer that is connected to all the different tables, but that does not seem to work at all.

Since I can't do that, I have created a Pivot table for each table (all pivot tables are on the same tab). Then when I create a slicer for any of the 5 new Pivot Tables, and try to "REPORT CONNECTIONS", the display only shows that Pivot table. What am I doing wrong? What can I do to link all of my pivot tables to a single slicer?

I have other slicers connected to multiple pivot tables, spread out over multiple tabs .. so I do not understand why it is not working here.

Please help

 

[denzo36]

If you are building Pivot tables from different tables which contain different data then you cannot have a slicer that controls them because the data behind them is different. You can only have slicers connect to multiple pivot tables that are using the same data source

 

[Sweedler]

That is what I was afraid of. But thanks for confirming