I currently have a table that I want to filter. I could make a filter pane but the filter pane selection would apply to the table and everything else in the sheet which I don't want. Is it possible to filter only the data in the table?
I learnt to use set analysis a bit which allows me to exclude tables from selections, but this isn't optimal as I want to apply filters to them as well.
Thanks in advance.