Hi, I wish to exclude from a dimension in a table an entry where the text includes emergency or unassigned as shown below.
| |
Desired Outcome |
| Engineer |
Engineer |
| Mike Smith |
Mike Smith |
| Andrew Smith |
Andrew Smith |
| Devon Emergency |
Gill Smith |
| Essex Unassigned |
|
| Gill Smith |
|
When I use if(not Match([Engineer],'*Unass*','*Emerg*'),[Engineer]), it returns all 5 engineers.
