you could write a formula and use it directly as a filter
contains([DIMENSION],'TRANSIENT') place it on the filter shelf and set to True
keep in mind it is a literal comparison
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.