Help needed to create new tables using existing tables and measures

Hi, 

I have been struggling with this for some time, and whilst I have been scouring the internet for solutions, I am not sure if I am phrasing the problem correctly in my searches, and would be very grateful if someone could offer some assistance.

I am attempting to build a report on my P&L data. It comes in the form of a report from our ERP resembling the following:

I then have a master reporting code table

a master department table

and of course a good date table...

I am able to create a matrix which reports on all the values in the Title columns, something like the following (filterable by date and department):

In order to calculate Gross Margin and Gross Margin as % of Revenue, I have created measures, however, I would like these measures to appear in my matrix (I currently can only display them in a separate visual). Ideally I want something like the following:

I suspect I need to create a new table, merging the data from the reporiting with the measures, and adding new rows in the tile 1 and title 2 fields to be able to map it and display it correctly in a matrix.

Is this possible? If so, how? Can someone please help, or point me in the direction of some online material which would guide me through it?

Thanks in advance!