Problem: Splitting each nominal into different months.
So far I've tried using nominal_product_ORDERDETAIL::c_MonthNumber to self join to 12 TO's with a calculated number corresponding to each month but the results just came up with the same values.
ORDERDETAIL contains lines of products bought. It has the information for dates, prices etc.
What would be the easiest method of me splitting the data into separate months based on the layout below.