Display Last Three Months

[Anonymous]

I have a field called DispLD, which represents the Load Date for file data.

I want to be able to show just the last 3 months based on this field. I have made an equation below in set analysis, which works, but is only showing the DispLD - 2. It is currently april, so the expression below shows results for February ONLY. I want to be able to show results for February, March and April.

DispLD = {'$(=Max(DispLD-2))'

DispLD is formatted as YYYYMM (i.e 201504 is April 2015)

Any help you can offer is appreciated.

[pokassov · Accepted solution]

DispLD = {'>=$(=Max(DispLD-2))'

[Anonymous]

Worked perfectly. Thank you for the quick response.

[maxgro]

in a chart with DispLD  as dimension

try expression

concat({$ <DispLD ={">=$(=date(addmonths(makedate(left(max(DispLD ),4), right(max(DispLD ),2)),-2),'YYYYMM'))<=$(=date(makedate(left(max(DispLD ),4), right(max(DispLD ),2)),'YYYYMM'))"}>} distinct DispLD , ' ')

[pratap6699]

DispLD = {'=date(=Max(DispLD-2),YYYYMM)'}