Link two tables, and show data from the 3rd|Power Pivot|Excel Forum|My Online Training Hub

I'm new to Power Query and Power Pivot.  I'm creating a dashboard, and having some trouble mastering the relationships between tables.   There's some constraints / database logic at work. 

In this simplified example I'd like to create a pivot table that shows the "Client Rate" applicable to the "Named Resource"
e.g. Amy, is an actor.  Actors are classified as Entertainment.  Entertainment has a client rate of $150.  Therefore I'd like to show in a pivot table Amy, and the rate of $150.  Refer to the image attached

Table A

Named Resource, Role A

Amy, Actor

Cristina, Bar person

Table B

Role B, Classification 

Actor, Entertainment

Bar person, Hospitality

Table C

Classification, Client Rate

Entertainment, $150

Hospitality, $180

The tables are joined 1 to many on Role (Tables A to B), and Classification (Tables B to C). 

When I create a pivot table with

• Named Resource & Role A in rows, and
• Sum of Client rate in Values,
  • The table contains these values
    • Named Resource, Role A, Sum of Client Rate
    • Amy, Actor, 330
    • Cristina, Bar person, 330
  • I would like it to show these values
    • Named Resource, Role A, Sum of Client Rate
    • Amy, Actor, 150
    • Cristina, Bar person, 180

Hope that makes sense.  Can you help me achieve the above result, and understand the database logic that makes it work the way it does?