0 Replies Latest reply: Jun 17, 2017 6:37 AM by vivek sm RSS

    Color Expression Based Range of values pivot table

    vivek sm

      Hi,

       

      Iam trying to put background color based on the range of Numbers with blue color i am not able to get the color for the range of numbers

       

      Iam using pivot table

      For Rows = Hours
      Column = Weekday and date

      Measure = sum(calls)

      Used Expression in background color expression:

      ARGB(Sum(calls)/Max(TOTAL (calls),weekday,hour)*256,68,119,170)

       

      So can you help me out!