matrix display

[randomUser21]

Hello everyone ,

currently I have a matrix with a hierarchy like this:

 

how can I have a layout like this:
 

 

the hierarchy in this way and the background colors according to the value of the hierarchy

Someone can help me please

[Alf94 · Accepted solution]

Hi @randomUser21 ,

For the hierarchy you have to uncheck the following option in the rows headers menu:

For background color, I think best you can do is a conditionnal formatting for the values of the matrix. However I am not sure you can dynamically change the background color of rows headers.

If I answered your question, please mark my post as a solution.

Best,

[randomUser21]

i can't set conditionnal formatting  on row ?  it's only available on column  ?

[Alf94]

Not really. A matrix can be broken down in three parts : rows, columns and values. As far as I know, conditionnal formatting is only available for the values part, which is the "center" of the matrix.

[randomUser21]

@Alf94, ok thank you for your help