Hello,
I'm assisting some colleagues with a solution that helps track music session bookings. There are a number of summary reports set up, which the metrics are then displayed on a dashboard.
It's been set up for exactly a year, but they only want the current financial year's data to be displayed. They came to me asking to help them set up brand new sheets/reports/dashboard for this financial year.
Instead, I've recommended an archive function i.e. using the move row automation to an identical sheet, which would then mean keeping the same dashboard and reports would only display the most up to date data. What they'd also like though is to be able to compare and display last year's data in the dashboard.
I'm wondering if this is possible with the method that I've recommended (using perhaps a filter on the report to display the relevant data from previous years) or if having a new sheet each year is the best way to do this?