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.