Pretty much troublesome, but here is an idea of dynamic filter.
Design is very dirty but as concept.
"Reset" filter is another problem, and anyways trouble some approach..
But only the way I know of as to dynamic filter change...
Put "Blank" worksheet as mask.
Fruit Example_SM_10.5.twbx 17.8 KB
Thank you very much for your reply, I appreciate the effort you made but this is not the kind of solution I want to implement.
If it isn't possible using code/filters/sets etc. then I would prefer to leave it as is.
Maintaining the above is not fun.
I 100% agree with you.