Forum Discussion
Combining Two Data Matrices into One
Hi Everyone, I am currently working on a project where I need to create a single matrix that displays data categorised by various metrics. I have successfully created two separate matrices but am...
hi annaharris
Assuming they are from the same fact table, then you can just create a measure that filters to selected centre and the other one for Metro. If they are from different fact tables but share common dimensions, you can use a bridge table that is related to the fact tables that wil serve as a bridge between them. Without seeing a sample data that represents the actual one, it's hard to provide a more concrete solution.