2 Replies Latest reply: Jan 24, 2018 4:36 PM by Nathan Lin RSS

    Pivot Table: Color code

    Nathan Lin

      Hi everyone,


      I am trying to color code my pivot table. The value are ranging from -1 to 1. i try to make the data above 0 in Green and below 0 in red. And the same time, the color is also value associated.


      the current expression i use is:




      but the color is showed is below: Screen Shot 2018-01-24 at 1.28.31 PM.png


      any suggestion?'