Forum Discussion
AnnLT
1 year agoFrequent Visitor
Multiple unrelated Rows in Matrix - is this possible?
Hi All I am fairly sure this is not possible but wanted to reach out to see if any experts can solve this and if not reassure me that it is is not possible. A team member has asked me if we can h...
- 1 year ago
Hi AnnLT,
Let's assume, you have such a dataset:
You will need to create an auxiliary table like this and use the columns from this tables as rows in your matrix:
Then you will need a measure, the one like this:
And your problem is solved.
Check the attached file for details.
Best Regards,
Alexander
barritown
1 year agoSolution Sage
Hi AnnLT,
Let's assume, you have such a dataset:
You will need to create an auxiliary table like this and use the columns from this tables as rows in your matrix:
Then you will need a measure, the one like this:
And your problem is solved.
Check the attached file for details.
Best Regards,
Alexander