How to subset a symmetric matrix

[emskikay]

Hi,

I have a symmetrix matrix and I want to view a subset of it.  Say my full matrix has columns and rows A-Z.  These columns and rows are grouped.  Say Group1 has columns and rows A-E and Group2 has columns and rows F-K.  Group 3 may have columns and rows Q-S and Z.  A group will have different number of columns and rows.

I want to view a subset of the matrix by group.  I have a slicer with the list of groups that filters another slicer with the column names.  I can get it to filter the columns shown in the matrix.  But I can't get it to filter the rows.  How do I filter it by rows?  Any help would be appreciated.

[v-ljerr-msft]

Hi @emskikay,

Could you post your table structures with some sample/mock data and the expected result, so that we can better assist on this issue? Do mask sensitive data before uploading. 

Regards

[emskikay]

Hi there, here's a sample mock data. Say I have this full symmetric matrix.  G stands for group.  The matrix has 3 groups G1, G2 and G3.  A-H are locations.

Y	G1-A	G1-B	G1-C	G2-D	G2-E	G2-F	G3-G	G3-H
G1-A	1
G1-B	0.98	1
G1-C	0.95	0.87	1
G2-D	0.88	0.88	0.83	1
G2-E	0.92	0.91	0.85	0.89	1
G2-F	0.74	0.76	0.67	0.82	0.77	1
G3-G	0.82	0.87	0.69	0.92	0.82	0.77	1
G3-H	0.80	0.84	0.67	0.78	0.76	0.65	0.75	1

If I want to view the matrix for G3 only it should look like.  Where the columns and rows for G1 and G2 are filtered out.

Y	G3-G	G3-H
G3-G	1
G3-H	0.75	1

If I want to view G1 and G3 it will be like this

Y	G1-A	G1-B	G1-C	G3-G	G3-H
G1-A	1
G1-B	0.98	1
G1-C	0.95	0.87	1
G3-G	0.82	0.87	0.69	1
G3-H	0.80	0.84	0.67	0.75	1

The real matrix I am working on is 200 x 200 and it will grow bigger.  So it'll be good to allow users to view Groups that they are  interested in.  It will also be good if they can select locations (ie any other second variable) to view.

Is this possible?