Reports: Filter based on Current Month
One of our clients has a sheet which tracks data by month for a number of regions. They would like to display only the current month's data on an Executive level Dashboard, therefore displaying the data for all the regions together as a snapshot for the current month.
My thought was to create a report and then filter by the current month, but there is no option to do that.
Does anyone have any ideas how best to achieve this? I can add additional columns to the Sheet if that helps bring a filter in, but the client obviously does not want to have to go into the report to change filter criteria every month.
I hope that makes sense. If not, please let me know.
Many thanks in advance for all your help.