Forum Discussion
Anonymous
5 years agoNot applicable
Table: expand and collapse columns
I am designing a table with many columns. The columns can be grouped by diferent concepts. In this example "Prov €/caja", "Prov Img" and "Total provisionado" can be part of same group. ...
webportal
Impactful Individual
5 years agoYou 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!
Anonymous
3 years agoNot applicable
Thank you very much. Your suggestion is very effective. Through SWTCH and HASONEVALUE, you can dynamically expand only the weekly details of the current month