Welcome to the community, and thanks for your request!
You can achieve what you'd like to do by simply adjusting your data model. For example, you can create a table of "Months" and another column in your "Expense" table to specify the month that an expense corresponds to.
Here's the new table to add months:
And here's a Month column in the "Expense" table that is formatted as a rowlink to the "Months" table:
Then in the app, you can display a list and filter to only the expense data of a selected month.
I created a list of the Expenses table, and using the Filter and Sort features, I specified for app users to be able to filter the list by a selected month:
Here's how it looks in the app. You can select which month's expenses you'd like to view:
This method allows you to retain or "archive" the data of previous months in the tables, and you can control in the app which data displays for the users.
Let us know if that idea helps!
This topic was automatically closed after 14 days. New replies are no longer allowed.