Skip to main content
DD-RET-004 Enterprise Retail Profitability and Inventory Optimisation Get the data →
DD-RET-004-Q049 Very Hard Time series

Worst month against budget

Which month shows the largest adverse variance of actual net sales against budget?
Expected
Monthly variance table; most adverse row · Variance column chart
Tables
FactSalesTransactions, FactBudgetMonthly, DimDate · columns
  • FactSalesTransactions
  • FactBudgetMonthly
  • DimDate
  • NetSalesSAR
  • BudgetNetSalesSAR
  • TransactionDateKey
  • BudgetMonthKey

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