Forum Discussion
subgroup in matrix visualization
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
4 Replies
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.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
