If statement for dimension, exclude fields

[evansabres]

I have a field, 'Group' that I am using as a dimension. I want to exclude certain values from the dimension, such as 'ABC', 'DEF', and several others. What is the proper syntax for that.

[sunny_talwar · Accepted solution]

You can do this as your dimesion

If(Not Match(Group, 'ABC',  'DEF'), Group)