Table formula for previous month data

[#1]

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

[#2]

got this (renamed the label to date). Formula still yields zero results

[sunny_talwar]

Few things come to mind

1) Do you have data for last month?

2) Do you have another selection made besides month which might be causing this issue?

3) Are you sure your date format is right? -> DD/MM/YYYY. Could it be DD/MMM/YYYY or MM/DD/YYYY

[#4]

well I changed YYYY to YY and that gives me numbers. But the same as the selected month

EX: EURX says 66899 for VpM now

[#5]

forget that last comment

will try to figure out what goes wrong...you helped a lot already