Calculated Dimension

[evansabres]

I have a field called 'capLEVEL'

I want to use this in a chart as a dimension, however when I use this field, i want to exclude the following, which are records in this field:

100 Preferred Rinkside

100 Level II Rinkside

100 Level III Rinkside

Hockey Suite.

How would I structure the 'expression' for my dimension

[sunny_talwar · Accepted solution]

May be like this

If(not Match(capLEVEL, '100 Preferred Rinkside', '100 Level II Rinkside', '100 Level III Rinkside', 'Hockey Suite.'), capLEVEL)

[evansabres]

Helpful as always, thank you