The date filter could be changed to a Relative date filter (green, continuous date pill) which can be set to show the last 12 months, which will be based on Today.
A postitive of this is regardless of the data loaded in your report the last 12 months will always be displayed on opening. A downside is the filtering functionality differs as it doesn't allow the user to pick individual months. However there's nothing stopping you using both the continuous (green) relative filter and the existing months filter, as long as you put the green filter into context the months filter will only allow selection of those 12 months (assuming you choose to only show values in context with the months filter.
This might be exactly what I need. I will have to experiment with changing the date type from discreet to continuous and creating a secondary filter. I will report back.
Hi Matthew - How about creating a set by filtering on top 12 months with the by field on the month id. We need to add this set to the filter section by selecting 'show members in the set'.
This will give you recent 12 months of data by default . Hope this helps.