Advanced filtrering capabilities on board and views

I need to apply advanced filters to my boards and board’s views. These must be able to combine several “where” clauses with nested “And” and “Or” conditions. For example, I have tables of over 100 items that I would like to filter on different statuses, and on this result filter again on a drop-down list and so on. Each filter must be independent and must allow “and” and “or” clauses to be switched between filter groups.

Thank