If anyone could let me know if this is possible idd appreciate it.

I have a table with rows of accounts that multiple employees are responsible for. In each row theres a column with all of those responsible employees separated by commas. Is there a way to add a filter to my pivot table so I can select one employee and it will show all the rows where that columns cell CONTAINS that employee name.

Account | Performance | Employees
Acct1 | Satisfactory | Mike, John, Laura
Acct2 | Arrears | Kim, Mike
etc..

In this case the filter would have 4 names singled out, and if you selected Mike for example, both of those rows would show.