I don't know if this will work for your datasource type,
or if it will cause a performance hit,
but you could try joining the datasource to itself,
left-joined where ManagerID = EmployeeID (copy2).
(I renamed Employee Name (copy2) to Manager Name).
Please see screenshot below and
workbook v10.3 attached in the Forum Thread.\
283265selfjoin.twbx 12.3 KB