3 Replies Latest reply: Oct 15, 2011 5:38 PM by Stefan Wühl RSS

    Month by Month report

    Mikael Hyensjo

      Hi,


      would like to create a fixed report with jan to dec month and then ytd values in the end of the report


      I have problem to create a set syntax with fixed columns, so that we always start with jan and if I select for
      example sep I would have values from Jan to Sep and then 0 in oct to dec.

       

      I have used the follwoing syntax

       

       

       

      sum({$<Year = {$(=only(Year)) }, Month = {"=$(>=(Month)-11)"}>}[Invoiced sales amount])

       

       


      But the problem is that wonth is not fixed .

       

      Regards mikael