Calculated Dimension

[NickBentley]

I am trying to make a calculated dimension from my 'Customer' dimension which only displays the customers that have the contain the word 'value' in their title. 

I have tried the expression below, but this in just giving me a 1 / 0 result (which I am assuming is yes / no) but would like the list of the 25 or so customers that I know have 'value in their name. 

=Wildmatch(Customer,'value*')

Thanks. 

[Vikash · Accepted solution]

Hi Nick,

Please try the below expression as your calculated dimension-

=If(Wildmatch(Customer,'value*'), Customer)

Regards,

VK

[NickBentley]

Thanks for the reply VK. 

Worked a treat! 

Cheers,

Nick