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

# Color coding columns by different measure values in cross tab

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.