Hi,
I would like to filter rows based on wildcard search passed via parameter.
For e.g. Filter all rows in report based on dimension "Title" by searching for "build" value.
"Title" dimension values: 1. Build certification path
2. Testing code
3. Building maintenance.
Result should display 1. and 3.
Appreciate any help with this.
Thanks,
Simon Runc was faster
Or use "Title" on the Filter shelf, then in "Condition by formula" use Simon's calculation
CONTAINS(UPPER([Title]), UPPER([Wild Card Filter]))
You don't need to create it as a calculated field then.
I'm also not sure you actually need to use the upper / lower case. When I tried it out with my own data it didn't check against lower or upper case letters.
I say this in case it's important for you to distinguish between upper and lower case letters.
