4 Replies Latest reply: Nov 6, 2014 4:06 AM by Sudhanshu Shrivas RSS

    Color not matching in pivot chart

      Hi Friends,


      I created a Pivot Chart with some dimensions. I took sum(target) adn sum(sales)  expressions.

      and for difference I took =column(1)-column(2).


      For color I coded =if(column(1)-column(2)<>0,RGB(255,0,0),RGB(0,191,0)).


      But the problem is some difference  values are in RGB(255,0,0)(RED) and RGB(0,191,0)) (Green).


      Is there any better way of giving color to the difference??