Combining Two Data Matrices into One

Hi,

Thanks for the solutions danextian ,  shafiz_p  and Ritaf1983  offered, and i want to offer some more information for user to refer to.

hello annaharris , based on your picture, you can create a table to put the Centres as a dimensional table, then create 1:n relationship between the diemensional table and the fact table with the key [Centres].

Then put the Centres of diemensional table to the row, then put the related column of fact table  or measures to the values column , then it can work.

If the information cannot help you, can you provide some sample data so that can provide more suggestion for you.

Best Regards!

Yolo Zhu

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