When I implement a filter on an A field, it can only have the values 1 and 2. In some cases the data set only has data with value 1. If in that case I apply a filter with the value 2. How can I make the table is shown empty in that case, because no data meets the filter.
Thank you for writing.
It is not possible to apply a filter on a non-existing member.
As a workaround, you can add one extra empty row that only has value 2 for column A.
In such a case, you can achieve similar behavior.