Forum Discussion
Solved
Multiple Groups in Matrix using the same column
I am tring to creat a matrix that holds groups from the same column with different combination.
SourceTable
| Group | Type |
| 1 | A |
| 2 | B |
| 3 | A |
Then add them to a matrix row , the type to the column, and a value that counts.
OutPutMatrix
| Group | A | B |
| Group 1 | 1 | |
| Group 2 | 1 | |
| Group 3 | 1 | |
| Group 1 & 3 | 2 | 0 |
CEllis , You have Create a new table
Group , Group Name
1 , Group 1
2 , Group 2
3 , Group 3
1 , Group 1 & 3
3, Group 1 & 3
Join it with the Source table group and use it in the visual
1 Reply
CEllis , You have Create a new table
Group , Group Name
1 , Group 1
2 , Group 2
3 , Group 3
1 , Group 1 & 3
3, Group 1 & 3
Join it with the Source table group and use it in the visual