Hangout: How to compare data and summarize with PivotTable
Technique: How to compare data and summarize with PivotTable | Why: Create a sales by state summary | Step 1: Create and name your tables | Step 2: Use XLOOKUP to combine data from the 2 tables | Step 3: Summarize with a PivotTable