Set Analysis Help

[tchovanec]

I am trying to show results from the previous completed month minus 1 year back. So I would like to get data from 05/2011 - 05/2012. Below is my expression, but it only returns the current months data, so 06/2011-06/2012. Any hep would be apprecaited.

SUM

({<CAL_CENSUS_DT.Date={"<= $(=MAX(CAL_CENSUS_DT.Date)) >=$(=ADDMONTHS(MAX(CAL_CENSUS_DT.Date),-12))"},PT_CLASS={1,114}>}PT_DAY_COUNT

)

[chematos]

SUM

({<CAL_CENSUS_DT.Date={"<= $(=addmonths(MAX(CAL_CENSUS_DT.Date),-1)) >=$(=ADDMONTHS(MAX(CAL_CENSUS_DT.Date),-13))"},PT_CLASS={1,114}>}PT_DAY_COUNT

)