Different color for different rows of expression/dimension

[#1]

Hi All,

I have different TAT values depending on the values want to set the row color,

as if

If(TAT>20, color should be blue)

If(TAT>35, color should be orange)

If(TAT>50, color should be red)

have tried by visual cues but can only do it for one minimum and one maximum value for corresponding column

I am trying this in Pivot table chart

Please help me out into this

Regards,

Prashant A.

[Jason_Michaelides]

Hi Prashant,

In the expressions tab expand (click the +) the expression on the left and select background color. In the expression box on the right, put in =IF(TAT>20,Blue(),IF(TAT>35,Orange(),IF(TAT>50,Red(),White())))

The Orange() might need to be Amber() or something - can't remember! Check the F1 help for the preset colours, otherwise use RGB(r,g,b)

Hope this helps,

Jason

[jagan]

Hi,

Hope the attached file helps you in understanding the color expressions. 

Regards,

Jagan.

[Jason_Michaelides]

Oops - got the numbers back to front! Should have been:

=IF(TAT>50,Red(),IF(TAT>35,Orange(),IF(TAT>25,Blue(),White)))

Jason

[Anonymous]

Prashant,

You can try this.

If(TAT>20, RGB (0,48,255))

If(TAT>35, RGB (255,162,0))

If(TAT>50, RGB (255,0,0))

Regards,

Nandha

[#6]

Prashant,

You can try this.

if(TAT>20,red(),(if(TAT>35,Blue(),white()))

Regards,

HarshVardhan