Aggregating by Dimension Attributes: SUMIFS by Category and Region
This lesson is part of the course
In this lesson
You turn Larkfield Home's enriched sales rows into a category × region summary with SUMIFS, add totals and shares, and chart it as a stacked column chart.
Buy the course once for $9.99 to unlock every lesson and lab, the final exam and the certificate – lifetime access, no subscription.
Lessons in this course
- The Grain of a Fact Table: One Row per Order Line & the Duplicate Check Locked
- Surrogate vs Natural Keys: Key Mapping and the Unknown Member Locked
- Joining Facts to Dimensions: Enriching Sales with XLOOKUP and INDEX/MATCH Locked
- Aggregating by Dimension Attributes: SUMIFS by Category and Region Locked
- The Date Dimension: Date Keys, Quarters, Months and Weekdays from a Date Locked
- Slowly Changing Dimensions Type 2: Valid-From/To and the Right Version by Date Locked
- Many-to-Many & Bridge Tables: Spotting Double Counting and Allocating with Weights Locked
- Model QA: Orphan Keys, Inner-Join Losses and Reconciling Totals Locked