background colour in a cross-table

[Anonymous]

Hi,

I'm trying to set a background colour for a dimension in a cross-table. But I don't want this colour to affect the total Column.

How is it possible?

I don't see a possibility to set a background colour separately for normal columns and a total column. If I set a colour, it affects all columns.

Thank you in advance,

Larisa

[stigchel · Accepted solution]

In the dimensions tab expand the options of the dimension by clicking on the plus sign in front of it. In background color use the following expression:

=if(Rowno()>0,rgb(0,100,0))

[Anonymous]

Thank you!