We used to create a lot of reports based on monthly snapshot data. It requires a mandatory filter based on Year Month and users like to see the latest month data as the default view.