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.


      Please refer above screenshot.


      Kindly suggest some solution


      Thanks & Regards

      Ahmar Ansari