This content has been marked as final. Show 2 replies
I have a straight table chart where I am trying to filter out a value using a wildcard. What I am trying to do is exclude any instances of where the field value has TEMPLATE somewhere within in it.
Here is an example of a field value that I am trying to exclude:
PRJ-10014 - TEMPLATE - Management Activities
I attempted to created a calculated dimension
=If ([Proj Number & Name] <>'*TEMPLATE*', [Proj Number & Name])
but it is ignoring the wildcard.
Any help would be greatly appreciated.