Filter Multi-Select column based on Select Control

I have a table base on seasons and years, I want to filter for a year’s (12 months) work of data based on a select control.

For example:

Select Control = Winter 378 – the view should show data for Winter 378, Autumn 378, Summer 378, Spring 378


Select Control = Summer 378 – the view should show data for Sumer 378, Spring 378, Winter 377, Autumn 377

To achieve this I’ve created a calendar table for each of the year/seasons and created a multi-select column (Calendar Range) where I’ve defined which Select Control (Header Date) results should result in that season/year being filtered.

I have tried:

Calendar Range.filter(Header Date)

Header (Calendar Range)

Calendar (Header Date)

Calendar Range.contains(Header Date)

And no results are found

What am I missing?

Thanks guys

Welcome to the community!
I don’t know your control name, but it seems like

calendar range.contains(select control)

should work.


Something like this?

Looks like that sorted it - thanks so much guys

1 Like