Filter specific word in strait table

[tappij2012]

How do I make filter with in a strait table, where I use one dimension and several expressions?

I'll want to make different tables, where I want to use this filter.

For example:

So I'll want to use => if(Customer = '*We*', Customer) to show one table with all the customers contains 'We'.

When I'll do this, it doesn't show these customers, but only a -

Normally, when dimension is Customer, it shows of course all the customers.

[sunny_talwar]

Are you using this as dimension or expression? I hope as a dimension? Would you be able to a share a sample where this isn't working?

[jonathandienst]

The = operator cannot do this sort of search, use Like instead:

if(Customer Like '*We*', Customer)

But, as Sunny said, the correct solution depends on where/how you are planning to use it.

[tappij2012]

For Example:

I want to see a table witch shows only the rows 2 and 4 for this case.

[sunny_talwar · Accepted solution]

Try like this

If(WildMatch(Customer, '*We*'), Customer)

[tappij2012]

Thanks for your answer. This helps!

[jonathandienst]

Either of these should work as a dimension (they are functionally the same so which one to use is simply a matter of style):

If(Customer Like '*We*', Customer)

If(WildMatch(Customer, '*We*'), Customer)

Remember to suppress null values in the dimension.