1 Reply Latest reply on Aug 25, 2016 2:59 PM by P N

    Color coding columns by different measure values in cross tab

    Katherine c

      I am trying to change the color of each measure values using different

       

      I would like to color code all the measure values "unit velocity and " dollar velocity" columns with green for >0 and red for  <0 by comparing latest with previous of each measure and color coding it red and green. I created a calculated field for color coding but it works for only one measure values.

       

      IF

      ([Unit velocity - POS] - LOOKUP([Unit velocity - POS], 1)) > 0

      THEN "Increase"

      ELSEIF

      ([Unit velocity - POS] - LOOKUP([Unit velocity - POS], 1)) < 0 

      THEN "Decrease"

      ELSE "Zero"

      END

       

      I want to do some thing like as below

       

      IF  [Measure values] = [Unit velocity - POS] then

              IF

                  ([Unit velocity - POS] - LOOKUP([Unit velocity - POS], 1)) > 0

                     THEN "Increase"

                     ELSEIF

                          ([Unit velocity - POS] - LOOKUP([Unit velocity - POS], 1)) < 0 

                          THEN "Decrease"

                     ELSE "Zero"

                     END

       

      ElseIF [Measure values] = [Dollar Velocity]

                IF

                 ([Dollar Velocity] - LOOKUP([Dollar Velocity], 1)) > 0

                     THEN "Increase"

                     ELSEIF

                          ([Dollar Velocity] - LOOKUP([Dollar Velocity], 1)) < 0 

                          THEN "Decrease"

                     ELSE "Zero"

                     END

       

      ElseIf .......

       

      END

       

      Is there any workaround i can achieve this color coding each measures differently.

       

      Any help is appreciated.