Forum Discussion
Table: expand and collapse columns
You need to build a table to define how you want the groupings.
For example:
Group1 | Group2
A | Total provisionado
A | Prov Caja
A | Prov Img
B | etc...
Then, on the matrix, you add both fields to the Columns: Group1 and Group2.
This will add a hierarchy to the columns.
Finally, to display the right values on the matrix, you will need to build a calculated measure:
Measure =
SWITCH( Group1, "A", SWITCH( Group2, "Total provisionado", [Total provisionado], "Prov Caja", [Prov Caja], ....)
Hope it helps!
Thanks for your answer but that is not what I want to do.
I don't want to display diferent columns by selecting diferent groups.
I try to be able to display for every group (an I want to display all groups at same time) only the main column of each group or all columns.
Using my example, By default I want to display only "Total provisionado" column but If user press a button (+/-) then display all columns: "Prov €/caja", "Prov Img" and "Total provisionado".
It is similar to "+/-" button on matrix: