Forum Discussion
Solved
Displaying Detail data with Summary data
Hey all, I have two tables I'm working with, a detail table and a table more summarized costs. The detail table contains internal costs on a per - line level, and the summary table contains exter...
I figured this out after looking at VasTg's reply.
I created a new table with the distinct ID and ID2 columns, and then joined it to both the detail and the summary table. I used ID and ID2 for the rows in the matrix, and then values from both the details and summary columns worked as expected in the matrix.
I would recomment to create two tables(Dimension) for ID and ID2 with unique values as below
ID
1
2
ID2
1
2
Define relationship from ID to Detail(id) and ID to Summary(id) - 1 to Many
Define relationship from ID2 to Detail(id2) and ID2 to Summary(id2) -1 to Many
You matrix should work after that.
If this helps, mark it as a solution
Kudos are nice too
Do you mean two additional tables?