Filter Pivot Table with Data in the Pivot Table

Hi there,

I have a database with employee names and associated projects name and hours the person is working on, sometimes there are multiple projects one person can work on.

Now I need to create a slicer/filter that shows the project name. hopefully, through this slicer, the pivot table can show employees work on the project but also shows all the hours(not only on the selected project, but also other projects he/she is working on.

since I have employees that work on multiple projects, I can not build a direct relationship between a different table just with names and project names.


Any thought on how could I do this?