Dashboard filter column if it contains the number


I created a dashboard with 2 views. One view contains the results and has a field (SalesRepList) in it the can hold multiple Sales Rep Numbers delimited by a ~. The other view is a distinct list of reps. I published the QSalesRP_SalesRepCode column from the 2nd view and then tried to filter the 1st view using it in the OrderHed_SalesRepList column.

It does work except it only returns exact matches instead any row that has the rep code somewhere in the SalesRepList field.

Is there a way to get the filter to do ‘contains’?

Any help is appreciated.