Forum Discussion
Custom Matrix help
I don't know what your data structure is, but based on the screen I can see that the test names are in one column. You can pivot this column, set test values as value. This will give you Test1, Test2, Test3 columns.
Source:
Pivot:
New structure:
This structure will allow you to add these columns to the Values field in the Matrix settings and the Higher column will occur only once.
The result:
Proud to be a Super User.
If I helped, please accept the solution and give kudos!
LinkedIN
Hi lkalawski ,
I would like the column 'higher' to appear only once in the table vs per variable since the values are the same always.
thanks
Laura
I don't know what your data structure is, but based on the screen I can see that the test names are in one column. You can pivot this column, set test values as value. This will give you Test1, Test2, Test3 columns.
Source:
Pivot:
New structure:
This structure will allow you to add these columns to the Values field in the Matrix settings and the Higher column will occur only once.
The result:
| Proud to be a Super User. If I helped, please accept the solution and give kudos! |