Set Analysis Month -1

[zied_ahmed1]

Hello I have this set analysis like Month to date :

DateCal=,Year=,Month=,Quarter=,

DateCal={">=$(=MonthStart(max(DateCal)))<=$(=date(max(DateCal)))"}

I would like now to do Month to date -1 (if i select April  2017 i will have March 2017 )

Thanks for help 

omarbensalem‌

[zied_ahmed1]

DOS_REF_EXTERNE is my kpi

[sunny_talwar]

My bad, I wanted to see it in a table object...

[zied_ahmed1 · Accepted solution]

Hello,

I find the problem i need to add year=,month = in the variable :

Year=,Month=,DateCal = {"$(='>=' & MonthStart(Max(DateCal),-1) & '<' & MonthStart(Max(DateCal)))"}

[sunny_talwar]

Bro you are a genius, I sometime wonder why do you even seek help as you are able to solve your issue 9 out of 10 times

[zied_ahmed1]

Hahaha yes sometimes i find my problem