Thank you for the quick response but unfortunately i'm having little trouble
Product Rapid Revolver: FY April 2017 to FY August 2017 running total is 262 (20+29+86+24+103)
Same product for FY 2018 is 129 (20+25+46+15+23)
the difference i was looking for is 129-262 = (133)
hope that makes sense and sorry if i wasn't clear enough in my original post
so sorry about that, really appreciate the help
Here you go:
I created 4 more calculated fields, Fiscal Year, Fiscal Month, Latest Reporting Fiscal Year and Latest Reporting Fiscal Month. It can probably be simplified but this will help in debugging easily. Also modified are the formulas for the Cumulative CY and Cumulative PY. You can refer them in the attached workbook.