Filtering-out a list of values in an expression

[Anonymous]

I need to hide multiple values for a dimension using an expression.  We do not want to limit this data on loading, so this is not an option. 

I've successfully used <> for a single value, but do not know how to handle multiple values. 

[swuehl · Accepted solution]

=If( Not Match(FIELD, 'Value1','Value2','Value3'), FIELD)

as calculated dimension or using set analysis in every aggregation function in your expressions:

=Sum({<FIELD -= {'Value1','Value2','Value3'} >}Value)

[Anonymous]

Thanks!