Master Calendar and Sheet Filters

[profilejamesbond]

Hi,

I have two tables island (table1 used in sheet1 and table2 used in sheet2) and both tables have date field and I created a master calendar and linked both tables based on date field. Now, I have filter such as Year, Quarter, Month, etc...

Now, the problem is when I select Year filter on sheet 1 then it reflects to sheet 2 year field. I want to stop it without alternate state. How to do it ?

More, I want to show these filter only on the respective sheet. For example: If I am on the sheet 1 and select Year and later jumped to the sheet 2 then I don't want to see Year selection on sheet 2 and when I jumped back to the sheet 1 then I want to see the filter selection of sheet 1 not from sheet 2.

Thanks

Thanks

[Kushal_Chawda · Accepted solution]

@profilejamesbond  If you want to do it without alternate state then don't create common calendar, have a separate calendar for Table1 and Table2. Calendar 1 link to Table1 & Calendar 2 link to Table 2 and place it calendar 1 filters in sheet1 & calendar 2 filter in sheet2

[marcus_sommer]

To prevent the unwanted associations you will need two calendars - one for each island table. I don't know Sense very well but I doubt that you could natively adjusting the selection-bar which means it will show all selections.

[profilejamesbond]

Hi,

Yes, I went with 2 calendars.

Thanks

[profilejamesbond]

Can I make 2 calendars with sub-routine?