Matrix Visual with Multiple columns

[Anonymous]

Hi Team, 

I have the below data as in the table. 

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

I Need to show this data in Matrix visual as below

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

I Need to have Collapse and expand option to show the regiions also with certain filters like 

1. Major Region collapse will have West AND South all values
2. Pre collapse will have all Regions with "Y" in PRE column
3. Post collapse will have all Regions with "Y" in POST Column

Can anyone help me with this. Is it Possible to achieve?

Thanks in Advance

[tamerj1 · Accepted solution]

Hi @Anonymous 
Check this out https://www.dropbox.com/t/zm8ajcYXZeB5szxO

YOu 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 😅

[Anonymous]

@amitchandak , @tamerj1  Could you please help on this.