Skip to main content
DD-RET-003 Omnichannel Sales, Customer Behaviour and Commercial Risk Get the data →
DD-RET-003-Q034 Hard Time series

Margin change: rate versus mix

Decompose the change in gross margin percentage from 2024 to 2025 into a rate effect (margin within categories) and a mix effect (category weights). Which effect dominates?
Expected
Two effects in percentage points · Bridge chart
Tables
FactSalesTransactions, DimDate, DimProduct · columns
  • FactSalesTransactions
  • DimDate
  • DimProduct
  • GrossMarginSAR
  • NetSalesSAR
  • TransactionDateKey
  • CategoryName

Discussion

No one has posted here yet. Ask something, compare your result, or share how you solved it.

A free account takes a minute. Your draft is kept while you sign in.

Create a free account Sign in