Help with a calculation

[ShellyG]

Hi there, 

I need some help revising two formulas that I wrote... They are the following:

sum({<Assigned_Items, FM_TI_OFF={">=1<=32"}>}TICKETS)
-above(sum({<Assigned_Items, FM_TI_OFF={">=1<=32"}>}TICKETS))

The above is a month over month calculation. FM_TI_OFF={">=1<=32"}>} - this is a calendar offset which includes in set analysis the months without the current one (0). The problem with this calculation is that I would like it to work in a way to compare for instance August 2020 with August 2019. Instead, the way that the expression is written, it is comparing August 2020 with July 2020, which is not what I want...

Any thoughts? 

Thanks! 

[tm_burgers]

Do you have a date field as well; you could use the AutoCalendar Functions to use the MonthsAgo field; ie

sum({<Assigned_Items, YourDateField.autoCalendar.MonthsAgo={'12'}>}TICKETS)
-above(sum({<Assigned_Items,YourDateField.autoCalendar.MonthsAgo={'12'}>}TICKETS))