Set analysis combined with other filter

[Anonymous]

Hi

I have a table with columns using the following set analysis expression:

COUNT( {$ <PROCTYPE =-{''} >} SKSKODE )

PROCTYPE includes:

- Proc_A

- Proc_B

- etc.

AND

- NULL values, with I sort out using set analysis expression above.

I want my table to filter on for instance Proc_A, but the expression in my set analysis overrides the filter and my table shows all columns where PROCTYPE is not null not regarding the filter. Is it possible to only show for instance Proc_A without making another variable to use only in the set analysis expression?

[sunny_talwar · Accepted solution]

Try moving the negative sign in front of the equal sign

Count({$<PROCTYPE -= {''}>} SKSKODE)