AnsweredAssumed Answered

Nominal report by month

Question asked by globe11123 on Mar 31, 2017
Latest reply on Mar 31, 2017 by philmodjunk

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.

 

 

Screen Shot 2017-03-31 at 15.23.16.png

 

TO:-

Screen Shot 2017-03-31 at 15.24.07.png

Outcomes