Very tough question

I need to create a column of values on a matrix table in Power BI that draws from three different column sources. 

First the data table : 

Here is the mapping table : 

I need to create a matrix table that has these columns :

Net Sales 

Distribution Margin

RnD

SGnA

Division Margin

I would have to link the data table to the mapping table using columns Funct_Area and FA.  

As you can see I have to use the FA GR L2 column to get the Net Sales, RnD, and SGnA.

As you can see by looking at the mapping table, Distribution Margin is a roll-up of Net Sales, Cost of Sales, OMC, and Other COGS.   Division Margin is a rollup of Distribution Margin, RnD, SGnA, and Other Operating.

How can create this column that has just Net Sales, Distribution Margin, RnD, SGnA, and Division Margin?  

Do I need to create some kind of calculated field, group totals, some new kind of mapping? 

I'm at a total loss here and this is my 2nd attempt to get this problem solved from this forum.  Please help me someone!