colors

[#1]

Hi,

I have to background colors for the actual Qty in pivot chart like this->

1.if actual qty >budget Qty by >=80% greencolor

2.if actual qty >budget Qty by <=50% red color

3.Rest in orange color.

I dont want to add a seperate % measure.Rather i have to show colors in actual Qty measure row based on the above condition.

I need to implement this using visual clues.

At present i am getting only one color.

PLease help.

Urgent.

Thanks in advance.

[kji]

Dont use visual cues for this, rather us Background Color Expression like:

if(qty/[budget Qty] > 0.8, Green(),if(qty/[budget Qty] < 0.5,Red(), Orange()))

[#3]

Thank you.

But if i use the exprssions for background color the measure name is also taking the color of the first value cell.

How do i resolve this.

I want colors only in the text field and the measure names or labels should not take the colors.

Please help.

Thanks in advance.