Getting the previous months sum of data but ignoring the filter that has been selected

[Rogers2212]

Hi, I have a dashboard and it can be filtered by month. I get a sum in a KPI box and next to the box i want to show what the previous months volume is. 

I have used the below and modified it from another post however it only returns the same months volume. Any Ideas as to what i am doing wrong?

Sum({<call_date = {">=$(=MonthStart(AddMonths(Max(call_date), -1)))<=$(=MonthEnd(AddMonths(Max(call_date), -1)))"}>} totalcalls)

[sunny_talwar · Accepted solution]

@Rogers2212 May be this... make sure to ignore selection in MonthField because that will conflict with your set analysis unless you tell you expression to ignore selection in MonthField

Sum({<call_date = {">=$(=MonthStart(Max(call_date), -1))<=$(=Date(Floor(MonthEnd(Max(call_date), -1))))"}, MonthField>} totalcalls)