Has anyone ever created a Comparative Financial Statements for multiple years other then just Actual and Prior using Sage Intelligence?
Request is to be able to print Comparative Financial Statements that cover, for example, the last five years on one report.
Thanks in advance!
Sounds like Power BI would be a good choice. A direct ODBC connection makes assembling the required data easy.
Sage Intelligence can do this.
You have a Cell that contains the current year i.e. A1. A1 shows 2021
Add 4 Cells (A2, A3, A4, A5)
In Cell A2 use the formula =A1-1 (2020)
Cell A3 =A1-2 (2019)
Cell A4 =A1…
