Ok,

I am sure this is something simple and it is staring right at me but for the life of me I can't figure it out. I have a lookup column pulled from SharePoint that contains single and multiple names - no nulls  and I am trying to filter on this column. When I apply the filter I only get values returned for single names I don't get results if the name appears in multiple names.

For example if I select bunny and the field contains bunny the row is returned if it contains bunny, rabbit the row is not returned.

I have created a dataset using distinct values for the selection list and have tried to apply the filter with several different expressions - none that have worked.

I did try a filter from an earlier post the the used the iff statement but that did not work.

Any help would be appreciated!

Allison