Select row/columns for a matrix

[Anonymous]

Hello! The best way to explain my problem is by an example.

I have a data set with 4 variables, A,B,C,D, they are all categorical, i want to do a simple matrix by choosing in a filter the rows and columns.

 For example, If i select in the "filter" that i want A as row and B as column, i get this:

A B  b1    b2   b3 ....

a1

a2

a3

...

Is there anyway to get this? i have tried with markers but it is quite inefficient. Thanks and sorry for my english

[Anonymous]

Up! Lets see if someone knows how to do that..., otherwise i ll have to do it with marks, but with 7-8 variables, this is a lot of work

[TeigeGao]

Hi @Anonymous ,

According to your description, my understanding is that you want to display the matrix based on your slicer, based on my test, it is not supported to do that, the slicer can only filter data rather than the row or column.

Best Regards,

Teige

[Anonymous]

Thank you sir, i saw your post and i was trying some of your work, but as you say, i want to that, choose the row and column from my slicers.

I found the way to choose the rows in your post, but it doesnt work when i want to apply some filter from other page, i dont know how to link up the tables, lets see if someone knows... 

Best regards