5 Replies Latest reply: Jan 18, 2016 6:44 AM by ahmar ansari RSS

    Background colour using expression

    ahmar ansari

      Hi All

      I have pivot table with three dimension (Model, Month-Year, Product).I have a requirement to change the background colour using expression like

      if(Model='PERSONAL CATEOGRY', OR  Model='COMMERCIAL CATEGORY' OR Model='NOT MAINTAINED' OR Model='Total',RGB(163,245,268))

      It works fine,but when I arrange my dimension in horizontal direction the above expression doesn't work.

      Capture.JPG

      Please refer above screenshot.

       

      Kindly suggest some solution

       

      Thanks & Regards

      Ahmar Ansari