I have requirement like below,
For one of sheet I need to show selection for only Month='Dec', Year='2016', whenevr I am navigating to other sheet I need to clear the selection and show all data as it is.
Can you please suggest how to proceed.
Just use a trigger on the sheet to select / clear the values as necessary
or you can also use Alternate state for the particular tab (not sure how exactly you plan to use it, but the closest solution to you description seems to be adam idea of using sheet level triggers)
Go to sheet properties -> Triggers -> Actions
Then select the field and value
Thanks but can you please suggest how should i clear the selection for remaining sheets so that default view can be displayed.
Use on leave trigger on this same sheet to clear selections in Year and Month field or clear all fields (based on your requirement)
As per my original answer which this one just repeats, just use a clear field function on a leave sheet trigger
When I am clearing selection in access point default selection is not selected on a sheet where I have applied the trigger.
you need to set triggers 'on ActivateSheet'- so when you open the tab its clear all selection and next apply the year and month filters (order is very important)
and you can on leave for example clear all if you need but
Retrieving data ...