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 value of the hierarchy

Someone can help me please

 

  • 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,

     

     

4 Replies

  • Alf94's avatar
    Alf94
    Solution Supplier

    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

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

      • Alf94's avatar
        Alf94
        Solution Supplier

        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.