Display values from different tables under one column

[sprakash1192]

I have two tables - Sales and Production which store total units sold and produced by time period. I am trying to show total units from the two tables under one column, but becuase the values from two tables, I get two table headers in the matrix view:

I would like the result under one column as Total EUs and have production units from produciton table and sales units from sales table. Like:

Department	Total Eus
Production	28649409
Sales	28735616

Please advise.

[lbendlin · Accepted solution]

Create a measure that adds both values, and display the measure.

[sprakash1192]

I was able to create a new table with keys for Sales and Production and create a relationship between the new table and the individual data tables. After that, the new measure for the total sum worked with differentiaiton for each key.

[sprakash1192]

How will it differentiate the sum between sales and production?