I think you are going to need parameters to do this. See the workbook attached, I've set up the filters for 3 fields: Order ID (wildcard match), State (exact match), and City (wildcard match).
Hope this helps!
Search Criteria_v10.2.twbx 1.2 MB
It works like a charm.Thank you so much for the solution.
I have been struggling to achieve this and I really appreciate your help on this.