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
← Swipe the sheet to see more columns →
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 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 | ||||||||||
| 8 | ||||||||||
| 9 | ||||||||||
| 10 |
This question demonstrates a technique that can't be graded as a single cell formula (it needs another sheet, a real PivotTable, or compares two methods side-by-side). Read the explanation below instead.