Pivot Table picking up multiple tables and using Slicers.

[Joe Scutt]

Hi,

I've tried searching for this but can't quite get my head around it so hopefully someone here has had similar issues and can help!

Basically I have a spreadsheet which has a pivot table. The pivot table is picking up data from a table ( Sales and Cost values multiple lines for many SKUs sold in the month ). And I am using a slicer to filter the data on the pivot table.

Next I have some budget information on a separate table (Both tables have a month column in common). I want to put this into a pivot table also and then have 1 slicer affect the data on both pivot tables.

And possibly in the future add another tables/pivot tables.

Is this possible?

Thanks,

Joe

 

[Joe Scutt]

Ignore this I've sussed it