I am trying to split my quarter data into trailing 13 months and also the years, I am not sure how to do this. I have posted the original logic for the quarter data. So I need the columns 'Monthstart()' and 'Yearstart()' Please help!
Original formula for Quarter data column
=SUM(IF(QUARTERSTART(OT_Period)='10/01/2020',OT_Overtime_YTD))
The 'OT_Overtime_YTD' is the dollar amounts. Essentially the columns would be.
Region/Location/Employee/Monthstart()/Yearstart()