This should be able to be done. I have attached a sample workbook. First, a string parameter will be created that names how the user should filter. Then, a calculated field will be created from this, and show the wildcard quick filter for the calculation.
Hope this helps!
how to filter.twbx.zip 1.1 MB
Amazing!! You have no idea how long I struggeled with that. I didn't realize I could adjust the quick filter to a wildcard option. Thank you!
I am trying to do a similar work but then I am not displaying the filter in my table.
Example,, I have product name and sales in my table but I want o filter based on the customer id that is entered in the free form box. If the customer ID is not valid or not present in the data I should get a message saying "ID not found".
Is this even possible?