Creating a Parameter and Filter to Only return last 5 years out of 20 years of data in the report - This is a Consolidation Financial Report and has a Standard Report named Fiscal Year

SUGGESTED

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.

Parents Reply Children
No Data