I Have a Consolidation Report with last 20 years financial data and I want to create a filter so that the report only returns last 5 years of data, I tried including system parameters to the standard report 'Fiscal Year' First but whenever I run that report with the filter and parameter it doesn't return any values.
Also note that this Consolidation Report it self has fields where I can enter the date and period of the report required (when i'm in the spreadsheet in excel)
Maybe im doing this incorrectly, hope someone can advise on this.