Calculate actual hours to FTE in pivot

[kammend]

I have a timesheet that contains all worked hours for all resources. It also contains the role of that resource.
What I'd like to create is a chart based on a pivot in which the number of FTE is shown.

In another table I have calculated the number of hours per month (working days * 8 hrs)

Can I create a pivot based on 2 tables or is there a way to have the number of working hours into the TimeSheet table?