Matrix automatically summing columns

---

KristenMackey wrote:

 

I am trying to create a matrix in excel using multiple different tables with percentages, but when I put them into the table they are all showing the same value for each row. For example the rows I am using are:

And the data I am trying to put into the table is:

 

 

 

---

KristenMackey,

Based on the above sample data, you can directly use Letter field to create relationship among the four tables, then create a table visual to get expected result in Power BI Desktop.


Regards,
Lydia