I'm pretty sure this is possible, but it would be a lot easier to describe if you posted a packaged workbook (.twbx) with some sample data, as the solution has a number of dependencies on how your view is set up.
Attached is the packaged workbook. Basically what I am wanting to do is look at applications through June 1 of this year for Fall 2012 and compare to June 1, 2011 for Fall 2011 and June 1, 2010 for Fall 2010, etc.
Thanks in advance for you help!
AppStatus Min.twbx.zip 102.2 KB
You can do this by creating a date parameter and setting the APP_DECISION_DATE as a reference in a calculated field. Similar to the following:
if [APP_DECISION_DATE]>=dateadd('month', -2,[App Decision Date Parameter]) and [APP_DECISION_DATE]<=[App Decision Date Parameter] then [APP_DECISION_DATE]
elseif [APP_DECISION_DATE]<=dateadd('year', -1, [App Decision Date Parameter]) and [APP_DECISION_DATE]>=dateadd('month', -2, (dateadd('year', -1, [App Decision Date Parameter])))then [APP_DECISION_DATE] end
Then, place this calculation on the filter shelf, and exclude NULL.
Hope this helps a bit!