In the SEI Excel reporting, is there a way to have a trailing twelve month report that crosses fiscal years without having to have 12 hidden columns that you sum to populate your TTM column?
As an example, if you were reporting for June 2021, you would want to include July 2020 through June 2021 in your TTM column.
In the Formula Wizard you specify where to get the fiscal period and fiscal year, but can you pull both July-December 2020 AND January-June 2021 into one column?
Thank you.
Cindy