background colour

[Anonymous]

Hi,

I'd like to define a specific background colour for the total Column of a pivot table (see the file attached). How can I do it?

Thank you in advance,

Larisa

[Anonymous]

hi,

goto expression tab - expand expression (click +) -  background -  give =rgb(255,255,0)

[Anonymous]

Yes, I know about this possibility. But what I mean is a bit different.

I wat to set a certian colour for Total column ONLY, but not for the whole expression.

[petter · Accepted solution]

You can test for being in the Total Column (which programatically could be the Row if you have moved the dimension around in your pivot) by doing this:

(the expession for the background color)

     If( RowNo() = 0 , Yellow() )

[Anonymous]

hi,

please try:

if(fieldname ={value},rgb(255,255,0))

or

If( RowNo() = {value}, rgb(255,255,0) )

[Anonymous]

Thank you!