I have created a Sales Dashboard that shows information on Fiscal Year.
However, I need the same Dashboard to display data for previous years as well.
I tried to use a filter on the Dashboard, but every time it changes, takes about 15 (fifteen) minutes for the data to refresh.
I removed the Dates from the reports, fort this to work, since if I put a date filter on the report, the Dashboard filter and the report filter than negate each-other and I will get a 'zero' results dashboard.
Any idea on how to have such 'Yearly' dashboards that can look on historical years as well?
- Please do not suggest duplicate all the reports