I am trying to create a project budget spreadsheet. I placed each cost group on a separate sheet (2. Material, 3. Manpower, 4. Accommodation, 5. Subcontractors, 6. Other costs). Each table on each sheet has a column with calendar weeks, as my manager wants to be able to filter by CW.
I wanted to create a summary and put it on the first sheet. Therefore I created a pivot table for each cost group and moved it to the 1st sheet.
THE PROBLEM: I created a slicer for 1st pivot table and I would like to connect it to other pivot tables. However, when I go to Slicer --> Report Connections, there is only one pivot table.
I already tried the method of Changing the data source (as it was advised somewhere else). Unluckily, no success.
PS: Yes, each pivot table has a source on a different sheet (could this be a problem???)
PS2: Because of the language I am using, the KW=CW
Any ideas, please?
Thank you very much.
Hi Lenka,
Welcome to our forum!
Correct, the data split over multiple sheets means you cannot connect a single slicer to each PivotTable. Instead, you need to use Power Pivot and create a date dimension table that enables you to create relationships between the tables.
See green PivotTables and Slicers in the example file attached. If you'd like to learn how to use Power Pivot, please consider my Power Pivot and DAX course.
Mynda