Skip to main content
DD-MFG-002 Work Orders, Materials and Production Variance Get the data →
DD-MFG-002-Q036 Medium Time series

Actual cost per unit by month

For each month, calculate total ActualCostSAR divided by total ProducedQty. Which month has the highest ratio? Use earliest month to break ties and exclude zero denominators.
Expected
36 rows: YearMonth, ratio · Line chart
Tables
FactWorkOrders, DimDate · columns
  • FactWorkOrders
  • DimDate
  • ActualMaterialCostSAR
  • ActualLabourCostSAR
  • ActualOverheadCostSAR
  • ProducedQty
  • StartDateKey
  • YearMonth

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