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
)
