I have a visual with one multiselect filter on the sheet.
I want it that when that filter is being used whether that be a single value selected or multiple values selected it will update a second filter and use those exact same values selected for the filter on the sheet.
E.G., Filter 1 = Value 1 which will updated Filter 2 to equal Value 1, Filter 1 = Value 1, 2, 3, 4 will update Filter 2 to equal Value 1, 2, 3, 4.
I’m sure it’s a combination of paramaters and/or calculated fields but I can’t figure it out.
Any questions and please just ask, many thanks.