Background Color Pivot Expression Exclude Header

[denwo2010]

Hi,

I have a pivot and have the following for my Background Color

If([SLA]<[SLA Target], RGB(255,0,0),
If(IsNull([SLA]), RGB(214,231,247), RGB(0,255,0)))

It works but it is Highlighting the Header which I do want how do I exclude this from happening?

Thanks

[#2]

Hi,

Sparur and Amien, have you been able to solve this?

I'm having the exact same issue (Straight table, no total lines, header gets colored by expression's background color).

Thanks

[#3]

Gentlemen,

just to let you know that in the latesdt version of QV 11.2 the problem is finally solved:

The colour that the Background Expression assigns to the first row of the Pivot table does not apply to the Header anymore.

Regards

[#4]

Hi Fabrizio,

thx for your advice. Do you mean QV11.2 IR or do you mean QV11 SR2 ?

Regards,

Roland

[#5]

Hi Roland.

I'm referring to the latest 11.2 IR.

Regards

Fabrizio