master dimension

[johndoub]

i would like to create a master dimension that is a list of customers excluding customers with the last name 'SHOPPER'.

what expression should i use?

thanks.

john doub

[Arthur_Fong · Accepted solution]

In master dimension, try:

if(wildmatch(customer,'*SHOPPER*'),NULL(),customer)

Uncheck include null values after dragging this master dimension into your table.

[johndoub]

thanks very much.

that worked.