Skip to Content
Former Member
Dec 01, 2009 at 04:51 PM

Need all months of year in query structure but only data for year to date.


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.

Kind regards,