HI BW Gurus, we are on BI 7.0.
I am looking to complete the following in a BI Query.
We need to always have all months in year (1-12) in a structure in the colums but only have transaction data for the actual months to date and the remainder of the year months to be zero
So there must be 12 months always (Jan to Dec)
Example- say its "June". Even if there is transaction data for July to Dec it must be blank in the query but the respective columns must be there ie all 12 months.
Thanks in advance. Points will be generously awarded.