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

    Table formula for previous month data

    Arne Kanters



      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])