Hello,
I have 2 calendars and i want to swap the filtered calendar on button click by the user on the same charts. I've added a variable with "if "
:If(PICK_DATE = 'SHOW_ENQUIRYDATE', enquiryYear,dispatchYear)
and a selection field that picks calendar and it partialy works but i can't make the filters for the year and month cancel out the grayed out fields of the other calendar.How can it be done or there is another way?