Forum Discussion

randomUser21's avatar
randomUser21
Resolver I
3 years ago
Solved

matrix display

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 ...
Need Help
Show and Tell
Tips and Tricks
  • Alf94's avatar
    Alf94
    3 years ago

    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,

     

     

Alf94's avatar
Alf94
Solution Supplier
3 years ago

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's avatar
    randomUser21
    Resolver I
    3 years ago

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

    • Alf94's avatar
      Alf94
      Solution Supplier
      3 years ago

      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's avatar
        randomUser21
        Resolver I
        3 years ago

        Alf94, ok thank you for your help