Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
=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)
=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)
Thanks!