Matrix from different tables

[Anonymous]

Hello Team,

I want a summary table. I have values(Measures) in different tables which don't have any relationships. Only Year is common in all tables.  SL% from one table, Total from raw data ETC...

[Anonymous]

Hi @Anonymous ,

I found that your matrix also has row fields, and the row fields are related to your two measures?

Then your [total FTE] measure is all the same value, because your measure has no relationship with your row field, right? I don't know what your expected outcome will look like. If you can, please provide some dummy data, along with the desired result, and I'll try to help you achieve it.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

[Anonymous]

I have a calendar table and also i linked it, but when I pull data it's not i the proper way. I just need year in the column 

[mlsx4]

Hi @Anonymous 

Do you have a Calendar Date? If you don't, create one and use year field to link both. Then include in your matrix year column from Calendar Date with your measures from each table