2 Replies Latest reply: Sep 27, 2016 5:57 AM by Filip Duchateau RSS

    colormix, color gradient

    Łukasz Liziniewicz

      Hello all,

       

      I have pivot table with two dimmenssios (Quesion and Controller).

       

      The result is the average score the controller get for every question, scores: 1-6 (generaly the scores are close to the 6).

      My expression: avg(SCORE)

        

      CONTR_1CONTR_2CONTR_3CONTR_4
      Q15,885,165,645,61
      Q25,975,645,795,80
      Q35,885,245,815,59
      Q45,935,505,835,84
      Q55,935,245,675,76
      Q65,955,485,865,88
      Q75,965,675,835,86
      Q85,855,265,745,69
      Q95,925,475,725,76
      Q105,875,345,645,63
      Q115,935,475,915,94

       

      I would like like to collor the background of cells depends on the value. I expect  results simmilar as below:

      Przechwytywanie.PNG