Can you explain your data a bit more (or show an example) please ?
The quick answer is ... YES, you can configure the filter so that it shows the most recent date.
BUT ..... you mention Year and Month filters which make it sounds like there's 2 of them and that might not be so easy to do.
first you need to create date field out of the month and year
makedate(year,month,01) /*hardcode the day to first day of month
drag this date field to filter follow the below steps
1) To Select the current year default
2) To select the current month default
this will give the expected output
Hope this helps
Plz mark this answer as correct & helpful to close the thread
Thanks for your reply Naveen.
Yes for year I can do this.
For default values for month filter, I actually need to select all months as default whatever is relevant for that current year. And not just the latest month.