Forum Discussion

Jpahl2033's avatar
Jpahl2033
Helper I
4 years ago

Two Data Tables into one matrix

Hi,

 

I am trying to put two tables into one matrix. The first table works fine, but when i bring in the second data table, as a value, it only displays the total instead of by row during the data. I have these two tables connected by a one to many relationship from a data table. 

 

Thanks

 

 

 

 

Need Help
Tips and Tricks

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Make sure you have created a relation with correct columns, relation with wrong columns may leads to inappropriate data.

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    4 years ago

    Hi, Jpahl2033 

    Can you show the fields involved in your matrix? In addition, it is recommended that you use a separate date dimension table.

    Best Regards,
    Community Support Team _ Eason