Matrix Visual with Multiple columns

Question

Hi Team,&nbsp;&nbsp;I have the below data as in the table.&nbsp;&nbsp;RegionPrePostEastYNEastNYWestYNWestNYWestNNWestYYNorthYYNorthYNNorthNNNorthNYSouthYNSouthNYSouthNNSouthYY&nbsp;I Need to show this data in Matrix visual as below&nbsp;RegionSalesProfitCogsAsbMajor Regions10020030033Pre4420212Post551013222&nbsp;I Need to have Collapse and expand option to show the regiions also with certain filters like&nbsp;&nbsp;1. Major Region collapse will have West AND South all values2. Pre collapse will have all Regions with "Y" in PRE column3. Post collapse will have all Regions with "Y" in POST Column&nbsp;&nbsp;Can anyone help me with this. Is it Possible to achieve?&nbsp;Thanks in Advance&nbsp;

tamerj1 · Accepted Answer

Hi&nbsp;Anonymous&nbsp;Check this out&nbsp;https://www.dropbox.com/t/zm8ajcYXZeB5szxOYOu need to unpivot the Pre and Post columns then filter Yes values. unfortunately, I'm not able to post screenshots as I already exceeded the limit&nbsp;😅

Forum Discussion

Matrix Visual with Multiple columns

2 Replies

Related content

Matrix multiple Sort columns

Matrix, multiple columns

Matrix behaviour multiple parameters

Matrix Column Widths

Conditional Formatting a Matrix with multiple columns

Region	Pre	Post
East	Y	N
East	N	Y
West	Y	N
West	N	Y
West	N	N
West	Y	Y
North	Y	Y
North	Y	N
North	N	N
North	N	Y
South	Y	N
South	N	Y
South	N	N
South	Y	Y

Region	Sales	Profit	Cogs	Asb
Major Regions	100	200	300	33
Pre	44	20	21	2
Post	55	101	32	22