Multiple unrelated Rows in Matrix - is this possible?

[AnnLT]

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 have multiple rows in a Matrix that are not linked.

I have tried adding as rows but they seem to automatically link as a stepped view parent - child. From looking at previous forum posts i can see that the +/- can be switched off and stepped layout too buit this would be needed for each unrelated row example below:

Is there a way to have one Matrix but with many unrelated rows, there are 4 rows altogether age, gender etc and each would need to + to the groupings as below

	2022	2023	2024
+AGE 10-17 18-30 ......
+GENDER M F .......

at the moment i am getting :

+M 10-17 18-30
+F 10-17 18-30

Any advice would be greatly appreciated before we go down the route of adding a navigation panel to navigate between seperate matrix tables.

Thank you

[barritown · Accepted solution]

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

My YouTube vlog in English

My YouTube vlog in Russian

[AnnLT]

Thank you so much @barritown this has worked perfectly