16 Replies Latest reply: Oct 11, 2017 4:34 PM by VIJAY VIRA RSS

    Cell colors overwrite in Pivot

    Satish Kamath

      Hi All

       

      I need color to overwrite with below condition

      All row color should follow the pattern Green -> Amber -> Red -> Black

      For above example I need as below

       

      Zone  MB1  MB2  MB3  MB4

      East   G       B       B       B   --> Amber should turn to Black for MB3 & MB4

      West  R       R       R       R  --> Amber & Green should turn Red because pattern Green Amber Red Black

      North  B       B       B       B   --> All blacks

      South A       R       R       R   --> After Red no Amber allowed for MB3 & MB4

       

      I have attached TestRAG.QVW. For back ground color I have created variables

       

      Thanks in advance for your valuable suggestion