Forum Discussion

Peter_23's avatar
Peter_23
Advocate V
1 year ago
Solved

Matrix visual filter by column

Hi Community in this time, I have a matrix with many columns and rows.

 

Row value\Value ColumnA1B1A2B2A3
1     
2     
3     
4     
5     

 

So in my report I have a disconnect table(visual filter)  to filter other visual, e.g.  (Value Column)  Type Filter.

A3
B2
A2
B1

A1

 

So I would like to filter columns in the matrix, when I select one value in (type filter) I mean TF= A3 in the matrix should be:

Only columns, begin with AX and another MEASURE = 2 (this measure help you to select how many  A's do you like to show. (back))

 

Row value\Value ColumnA1A2A3
1   
2   
3   
5   

 

Another example; when I select one value in (type filter) I mean TF= B1 in the matrix should be:

Only columns: begining with BX and another MEASURE = 1 (this measure help you to select how many B's as you like to show.)

 

Row value\Value ColumnB1
1 
2 
4 
5 

 

 

Is this possible?

thanks in advance.

8 Replies