Excel
All Top 50 Excel & Business Modeling Questions#34
Connecting a Single Slicer Across Multiple Independent Pivot Tables
EasyDeloitteInterview Question #34
Asked at DeloitteYou have built an executive dashboard with three separate Pivot Tables: (1) Revenue by Category, (2) Top 5 Sales Reps, and (3) Regional Performance. You insert a 'Year' slicer on Pivot Table 1, but clicking it does not update Tables 2 and 3. Explain how to connect the slicer to all three tables.
Input Table: DashboardLayout
3 rows preview| Pivot Table Name | Source Table | Current State |
|---|---|---|
| PivotTable_Revenue | Sales_Data | Connected to Slicer |
| PivotTable_Reps | Sales_Data | Not connected |
| PivotTable_Regions | Sales_Data | Not connected |
Expected Output Structure1 rows
| Action | Outcome |
|---|---|
| Slicer > Report Connections > Check All Tables | Single click on Year 2026 updates all 3 charts simultaneously |
Interview Context
Asked frequently in data analyst and business analyst technical rounds. Focus on clean filtering, optimal indexing usage, and unambiguous column selection.
Microsoft Excel 365
E2fx
| A | B | C | D | E | F | |
|---|---|---|---|---|---|---|
| 1 | Pivot Table Name | Source Table | Current State | |||
| 2 | PivotTable_Revenue | Sales_Data | Connected to Slicer | Target [Enter Formula] | ||
| 3 | PivotTable_Reps | Sales_Data | Not connected | |||
| 4 | PivotTable_Regions | Sales_Data | Not connected | |||
| 5 | ||||||
| 6 | ||||||
| 7 |
Click on target cell E2 and enter your formula above.Shortcut: Click "Load Solution" to inspect