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
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