Forum Discussion
Helper IIDisplay values from different tables under one column
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.
Create a measure that adds both values, and display the measure.
3 Replies
- lbendlin
Super User
Create a measure that adds both values, and display the measure.
sprakash1192How will it differentiate the sum between sales and production?
- 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.