Multiple Groups in Matrix using the same column

[CEllis]

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

[amitchandak · Accepted solution]

@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