Background colours of pivot table

[anuradhaa]

HI,

I want to add background colours for below pivot table.

See attached image

Is it possible to do?

[avinashelite]

did you tried using my expression in the expression background color ??

[Chanty4u]

is this?

[anuradhaa]

Yes, it solve most of the case. only thing now i want is use light colr in my last right column

[anuradhaa]

See attached

[avinashelite]

try with the dimensionality() function

if(dimensionality() =0,yellow(),if(dimensionality() =1,grey(),rgb(255,255,255))

)

[vikasmahajan]

Like This ?

[anuradhaa]

Can you do it in attached qvw. It doesn't work for me

[vikasmahajan]

PFA

Vikas

[anuradhaa]

Finaly Did it with

=if(isNull(RowNo()),rgb(255,255,0),if(rowno()=0 and ColumnNo()<>0,rgb(255,155,100),if(ColumnNo()=0,Red(),rgb(225,225,225))))

AvinasheliteThank You for your Idea. You showed the way .

[avinashelite]

Cool glad to hear that I was able to help you