Try something like this
You can create a calendar with Quarters using,
DayNumberOfQuarter in your load statement, then in the set you can use that field to get max Quarter or previous Quarter.
// for Max Month recovery
Sum( {<Year=, Month =, MONTH_NAME = {"$(=MonthName(max(MONTH_NAME)))"} >} Recoveries)
// for max Year recovery
Sum( {<YEAR=, Month =, YEAR = {"$(=(max(YEAR)))"} >} >} Recoveries)
//for prev month recovery
sum({<YEAR=,
Month =,
MONTH_NAME = {"$(=MonthName(AddMonths(max(MONTH_NAME), -12)))"}
>} Recovery)
// for Last Year recovery
Sum( {<YEAR=,
Month =,
YEAR = {"$(=(max(YEAR)-1))"}
>} Recoveries)
regards
Ren
