Creating a group of values in a matrix

[Anonymous]

Hi everybody!

I'm trying to create a matrix, in which some particular values will be grouped, with others remaining ungrouped (added a table as an example). I tried to create a group, but the values are collapsed in the matrix, so only the group name is reflected. To add some details - there is no difference between those values, such grouping is needed just in representation purposes.

If somebody knows how it could be done, please share your knowledge.

Thank you in advance!

	Column 1	Column 2
Value A	1	7
Value B	2	8
Value C	3	9
Group:
Value D	4	10
Value E	5	11
Value F	6	12

[Greg_Deckler · Accepted solution]

@Anonymous - You will need 2 groups, Ungrouped and Grouped So think hierarchy

Ungrouped	A
Ungrouped	B
Ungrouped	C
Grouped	D
Grouped	E
Grouped	F

I have built a custom hierarchy for columns in a matrix but not rows.

[amitchandak]

@Anonymous ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.