Hello
I am wanting to use a formula to consolidate the prior 12 months (can be over two fiscal years; ie: April 2022 to March 2023) into a single column but can't figure out a formula. I already know how to use the column formulas for each individual month, but I want to keep my columns less busy with a single consolidated column. The 32 character limit means I cannot do a single formula with [-11M]+[-10M]...+CM or -11M|-10M|...|CM
Is there a single formula to get this done?
I've tried these but they give errors:
Comparison Date Formula: CM-11M..CM
Comparison Period Formula: -1FY[CP]..FY[CP]