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??

       

      Thanks

      Pavan