Background Colors

[#1]

Hi,

I need to compare 2 measures which i am plotting in a pivot chart ,

if measure1 is less than measure2 then i have show measure1 in red.

But if i give in visual clues for less tha condition as sum(measure2) and set a background color all values of measure1 are comming in that color only whether its lesser or greater.

if i try writing the expressions in the background option under measures the measure1 name is taking the color of the 1st column value.

How do i solve this issue.

Please help.

Its urgent.

[#2]

Hi

Please see the attached file.

Thanks

Saran.

[#3]

Thank you.

But i have my meaures in the rows .

If i shift the measures from column to rows in the ex sent by you again i am facing the same problem.

the measure name is taking the color of the first value.

Can you please help me to resolve this issue.

[#4]

Hi,

Can you upload your sample report file. So that it will be easy for me to fix your problem.

Thanks

Saran.

[#5]

Hi,

Please check this.

As u can see the measure name is also taking the color.I dont want it to happen.

Sorry due to some security policies cant send the exact desired report.

[#6]

Hi,

Please check the attached file.

As you can observe the measure name is also taking the color of the 1st value.This should not happen.

Due to some security issues it is not possible for me to share the exact QVW.Sorry for that.

Please help.