Bear with me as this is my first time posting!

Referencing the screenshot attached, I am attempting to pull data from the Pivot table, matching Resource types and populating the Week1, Week2, Week3 columns with a %. (% utilization per week for each resource type). I have several other sheets and several Named Ranges, Tables etc.

I am populating the StaffResource column in the Resource Type Dashboard with a named range (Resource2) on the Legend tab.

The other table (L2:O12) is a pivot table that combines all hours for each Resource type entered in a separate table(Project Assignment - not shown). The PivotTable works great. As additional resources and hours are added to the Project Assignment table, the Pivot table updates.

However, when I try to pull the data for each row of the PivotTable as it matches the values in the Resource Type Dashboard columns, i always end up with just the ".NetDeveloper" hours.

=GETPIVOTDATA("Sum1",$L$2,"Resource Type",".Net Developer") How can I make this work for each resource type in the Resource Type Dashboard table?

Thank you!!! many hours spent trying to figure it out on my own cuz I'm too darn stubborn!

resources.jpg