subgroup in matrix visualization

[vrv]

Hi all,

I have a matrix visualization with some sum of amounts for value and Q1, Q2, Q3 and Q4 for columns.

I need a subgrouping for each quarter. The underlying table does have a flag column and my subgrouping should show the sum of amounts for each quarter when the flag is set on 0 and alternatively, when it is set on 1.

Namely from this:

	Q1	Q2	Q3	Q4
Point A	100	200	250	150
Point B	250	350	200	100
Point C	300	400	500	300

I need to do this:

	Q1	Q2	Q3	Q4
	myFlag = 0	myFlag = 1	myFlag = 0	myFlag = 1	myFlag = 0	myFlag = 1	myFlag = 0	myFlag = 1
Point A	40	60	60	140	50	200	30	120
Point B	50	200	60	290	40	160	20	80
Point C	80	220	90	310	80	420	30	270

Thanks,

vv

[amitchandak]

@vrv , if the first one is matrix then you should able to add a flag and expand it.

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

Appreciate your Kudos.

[vrv]

amitchanddak,

thank you for your reply.

Yes, the first table is a matrix.

I am adding the flag field to the columns, under the quarter column but nothing happens to the visual.

I expect to see the table as my second table in my initial message.

What am I missing?

Thanks,

vv

[amitchandak · Accepted solution]

@vrv , have you used expand icon?

[vrv]

yes, I did. Thanks, it's working now!