13 Replies Latest reply: Nov 16, 2016 10:23 AM by Arne Kanters RSS

    Table formula for previous month data

    Arne Kanters

      Hi,

       

      Within this overview I have selected one month of data. In the column Sum([#quantity]) the volumes per sublevel are depicted.

       

      Now, in the next column I want the volume of the previous month. Currently this is set at:

       

      sum({<Month=, Date={">=$(=monthstart(max(Date),-1))<=$(=monthend(max(Date),-1))"}>} [#Quantity])

       

      However, it does not work as you can see. Any idea how to resolve this?

       

      The field is Month, and the data is Sum([#quantity])

       

      qks1.JPG