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

    Month by Month report

    Mikael Hyensjo


      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