Change order of drill in matrix

[Joe_100]

Hi,

I have a matrix that can be drilled down on products and the products can be further drilled down to relations. So i can see a product per relation.

Now i want to change the order, so first see a relation and drill it down to which products it bought.

Off course i can copy the matrix and change the hierarchy in drilling, but is there a way to do this in the same matrix?

In other words i just want to have a sort of changable view in the matrix.

Thanks!

[Maddy99 · Accepted solution]

It is not possible to do this in the same matrix. 

but if you dont want 2 visuals in you report maby a bookmark can work.

make 2 different matrix an put then on top of each other. 

make 1 bookmark with matix 1 visable en matrix 2 disabled. 

and an other bookmark with the opist, matrix 1 disabled and matrix 2 visable.  

as last make a toggle feel picture. like a on and off button. https://www.youtube.com/watch?v=_Afcj8mT5_Q 

user can then switch to which matrix they want  to see. everything else look the same also filters only a different visual. 

can this help?

[Joe_100]

Works perfectly, had some trouble finding where to hide the visuals.

It's under;  view - selection pane.

Many thanks!