How to exclude certain records from appearing in the straight table.

[jayati_shrivast]

Hi all,

I have a straight table with column names, i need to exclude  certain names from appearing in the staright table, how can i do that??

[vardhancse · Accepted solution]

Hi,

Using calculated dimension we can able to achieve your expected output.

aggr(only({<Employer-={'A','B','C'}>} Employer),Employer)

or if you prefer "if"

aggr(if(match(Employer,'A','B','C')=0, Employer),Employer)

In any case, check "suppress when value is null"

[agni_gold]

could you please explain more ?