Which market is dragging group margin down?
DELargest margin decline, year over year
26.6% in 2025 against 29.1% in 2024, down 2.5 points
26.6%DE
34.4%FI
37.2%SE
40.2%NO
36.0%DK
DE ← cause26.6% −2.5pts
FI34.4% +0.0pts
SE37.2% +0.0pts
NO40.2% +0.1pts
DK36.0% +0.3pts
What the model is telling you: Four markets moved inside a point. DE accounts for essentially all of the group decline, so the next question is inside one market rather than across five.
- Metric
- Gross margin, group
- Definition
- (Net revenue − COGS − inbound freight) ÷ Net revenue, blended over the selected period
- Grain
- Market × ISO week
- Owner
- Group CFO
- Source of record
- ERP sales ledger, reconciled to finance account group 4000–6499
Show the SQL the semantic layer runs
select m.market,
sum(r.net_revenue) as net_revenue,
sum(f.cogs + f.inbound_freight) as cost_of_sales,
1 - sum(f.cogs + f.inbound_freight)
/ nullif(sum(r.net_revenue), 0) as gross_margin
from analytics.fct_order_lines f
join analytics.dim_market m using (market_key)
join analytics.fct_invoiced_net r using (order_line_key)
where f.iso_week between {{start_week}} and {{end_week}}
group by 1
order by gross_margin asc;Computed in your browser from 520 bundled weekly snapshots (520 rows scanned for this answer) over market x ISO week grain. Northline Distribution AB (synthetic) is a synthetic data set generated for this demo, not client data. Definitions, owner and source shown are the ones the layer would carry in a real deployment.