Back to lesson
1. Assume you have two PivotTables (Sales and Inventory) which both include the “Product Size” field. You’d like to give your end user the option to filter the PivotTable to only select product of a specific size, but want to keep both tables filtered by the same sizes. How would you do this?
Select a cell in the Sales pivot, add a slicer for Product Size. Ensuring a cell is selected in the Sales Pivot, go to the PivotTable Tools > Analyze (Options in Excel 2010) > Filter Connections and link the PivotTable to the slicer.
Select a cell in the Sales pivot, add a slicer for Product Size, select it, go to the Slicer Tools tab > Report Connections and link it to both PivotTables.
Go to PivotTable Options > Totals & Filters > Report Connections.
2. Assume you created two PivotTables: Sales is in columns A:B and Inventory is in columns D:E, as shown below. You’d like to keep both tables filtered to the same category, so you select E2 and type =B2. What would you expect to happen when you try to commit the formula?
You would receive an error as you’re not permitted to type into a Report Filter cell on the worksheet.
You would receive an error as you’re not permitted to link two report filters in this way.
The reports would link and stay in sync.
3. Assume you’ve got the Sales PivotTable (on the left) and the Inventory PivotTable (on the right) linked to the Category slicer as shown below. You then decide you only want the slicer linked to the Sales table (on the left). How would you correct this?
Select a cell in the Sales PivotTable > PivotTable Tools > Analyze (Options in Excel 2010) > Filter Connections > Uncheck the Slicer.
Select the Slicer > Slicer Tools > Report Connections > uncheck the box next to the Sales PivotTable.
Select a cell in the Inventory PivotTable > Right Click the Slicer > Unlink from PivotTable.
Back to the top
© 2017 GoSkills Ltd.
Skills for career advancement