Hello @all
I have developed a calendar application which contains 3 sheets in that we have global and local filter selctions in the global selections we can able select multiple calendar names and year based on the global selections the sheet will display the dat. i have calendar display application sheet which contains local filter here and able to select only one calendar name and one calendar year. the question is in the selection sheet if i select multiple values in the Calendar display sheet it will display the min values and other sheets based on the selections made from selection sheet it will display the data but if user wants to change the calendar name in the calendar display sheet he can change using the local filter and display the value. so now again if i move to another sheet and come back to calenda display sheet it is displaying the values from the selections made from the selection sheet not the local filter selections can any one have any idea how can we get it done if we change the calendar name in the localfilter and move to another sheet and come back the values should be same?
