Calculate Total Cost of multiple projects by resource

[wkeicher]

I am looking for assistance in summing the total cost of a resource accross all projects based on hours X rate (Where rates are differentdepending on project).

Table of hours entered by Resource, date, projectid - 

Billable Hours = SUM(ActivityUpdates[RegularHours]) + SUM(ActivityUpdates[OTHours])

Table of rates by projectid and resource - Need to calculate the hours for given project multiplied by the resource rate for that project and sum all by resource.

Result - resource - total hours - total cost