One way to do this is to use parameters instead of using a global filter to get correct month. The parameter can be used to control every worksheet, but without having to actually filter out the day, thus allowing for the YTD to be shown.
Hope this helps!
Let me explain you the scenario. I have a dashboard where I have multiple sheets as well as multiple filters which are Global. In each filters I have many selections. There is filter for Date as well in the dashboard which is Global as well. So for each month I will select the current month in the date filter, so that all the number will of current month.
Now I have Table where I am showing Current month data as well as YTD (Addition from Jan till current month). Now If I select current month in date filter then YTD will not come.
So please tell me how to handle this?