Pivot table with 2 overlapping filter

let's say I have a table for the hours put by team members on each project with the name of the resource responsible for the project

Project	Reporter	Worked	Hours
Project A	Bob	Nancy	2
Project B	Nancy	John	5
Project B	Nancy	Bob	6
Project C	Bob	John	3
Project C	Bob	Nancy	4
Project D	John	Bob	1
Project E	Nancy	John	2
Project F	Nancy	Bob	4

I'm trying to have a pivot table, for Bob, that would list the hours spent on projects where Bob is designed as reporter but also Bob's hours in the other projects. So the result would be something like

Project A:
-Nancy 2hres

Project B:
-Bob 6hres

Project C:
-John 3hre
-Nancy 4hre

Project D:
-Bob 1h

Project F:
-Bob 4hres

I can't wrap my head around how to use the filters to get that. If I filter only the project where Bob is reporter, I'm missing all of Bob's hours in other projects. If I filter on lines where Bob has hours, I'm missing all the other resources' hours in Bob's projects.

I'm starting to thing I'll to create another column with a calculated value, but that would be a lot of rework when adding or removing new ressources that would need their report.