1 of 1 people found this helpful
Create type with set and select "PUMP" and "REFILL". Use this set into filter and select show members in set and show quick filter option.
Apply the data source filter on column "Type"
Data source filter will exclude the "Bottle" at data source level , so that when ever you use the quick filter.
you can only see "PUMP" and "REFILL"
Please refer to the below screenshot as well as the workbook that I am attaching to the reply for the same. I have created a set where I have excluded the "Bottle" element from the same & I have put it in the filters. You can also put the "Type" column in filter section which will also give the same result.
Thanks and Regards,
Hiding Bottle Element.twbx 10.4 KB