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

[sparur]

Hello, Rocky.

I have the same problem with a pivot table.

Your suggestion is work for Total line only. but not work for header 😞

see in my small example.

P.S. in Straight table - No problem

[boorgura]

If you have a requirement to have the subtotal at the bottom, I'm afraid you cannot solve this.

If that is not a requirement - just choose the option to have the subtotals at top in the Presentation tab.

For some reason I'm not able to attach the file.

[ivandrago]

The Total Mode is greyed out so how would you be able to move this to the top?

[boorgura]

In the Presentation TAB in the settings - set the Subtotals to be at TOP.

[sparur]

Rocky, thanks

but unfortunately I don't need in total line, so your suggestion doesn't solve my problem 😞

[boorgura]

Sorry - dint get you.

Do you mean - you should not have Total Line or should the Total Line be at the bottom??

[sparur]

I shouldn't have Total line in my pivot table

[boorgura]

Hmm... you have the same exact problem I do.

Check this one. this is what I use.

This is by custom formatting the total cells with background color and text color being the same.

[sparur]

Rocky, Thank you for your response.

but you don't understand my problem... please see in my qvw-example (I uploaded it some earlier). I have pivot table where my label of expression "Value" has green background. I don't want it. I don't need total line( check off "Show partial sums" for all my dimensions in presentation tab) and I don't want green header for my expression.

[amien]

Sparur, how did you solved this? having the same issue