Exclude value in Dimension

[asknyldz]

Hello everyone,

I want to exclude "Alfa" team in my pivot table. I need to see only Beta and Charlie values. What should i write in the "Enable Conditional" exactly?

I can't in Expression because i have too much expression. Is it possible to way doing in Dimensions tab?

Here is the "Team" list:

Alfa

Beta

Charlie

and here is the my Dimensions Tab:

[tresesco · Accepted solution]

You don't need 'Enable Conditional' expression here, instead use 'Calculated dimension' (click on 'Add Calculated Dimension'). Use the expression like below:

=If(Team<>'Alfa', Team)

And check  'Suppress When Value is Null'