1 Reply Latest reply: Nov 2, 2017 5:49 AM by Martin Pohl RSS

    Back ground colour in pivot table

    Jayaseelan K

      Hi Experts,

       

                I have an query in pivot table background colour. from the below image,  I have dimensions ITEM,PONO and Measure Sum(PRICE), I need to put background colour fro sum(PRICE) measure  with following condition

      if(Sum(PRICE)>10,Green(),Red()).

      EX1.PNG

      I have achieved the above one.


      But the my task is, the colour should come only for PONO not for ITEM. My background color formula should not affect the ITEM(Dimension) .


      I have highlighted the ITEM name which i don't what to do colour calculation.

       

      it is possible??

      EX2.PNG

      Kindly help me to do this task.

       

      Thanks,