How to a filter to whole sheet

[Id123789]

How to setup a filter to exclude data?

 for example: the data source i used is an excel file and i'd like to setup a filter to exclude if column A = AA for whole sheet tables.

please suggest how to do it. thanks. 

 

[Prem0212]

use this expression  if(column A <> 'AA',  column A)