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

    Color Expression Based Range of values pivot table

    vivek sm



      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!