This Screenshot show my unfilteres table:
As you can see I got a lot of data where my resultsqueeze and resultvalidation is empty. I want to filter those entries. What i did is Filter the whole sheet with the following statement:
FILTER ("reportdataextraction"."resultsqueeze" !='' and "reportdataextraction"."resultvalidation" !='');
But the statement is filtering every entry where either one of the columns is empty. This is my result:
What am i doing wrong?
Thank you for the help!
Bests,
Jonas Vennemann