Steve, I have tried your suggestions but no data is coming up.
Alessandro, It is working but then if I do select a month, the data doesn't update to the selected month. Is there a way around that?
Sandhya, I have done that and it is giving me what I want but as Steve mentioned, every time I come back to that sheet, my selection resets to current Year, Current Month. How can I set that up when the document is first opened?
set analysis filter data and no selection will change your visualization.
To show a month at first and then change it do as follow:
1) Settings -> document properties -> triggers
2) click "on open" -> edit action -> Add
3) in the field write your field name so in your case: Month
4) in the search string write: =Month(Today())
Save the document and open it again and ... let me know