Essentially, instead of having different tables for the same type of record (in this case, a record for each report), you should have a single base with all your revenue reports, and then use differentiating data to group and sort them.
In this case, I put together a quick formula that allows you to see the month and year of a report.
Then, all you have to do from there is link the report to the respective store, and you’re golden!
I was gonna type out a long walkthrough, but I decided this would be faster.
Let me know if you have questions about it.