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?

[Chanty4u]

go to grid style....and  right clik on table  do select custom format cell   and do the font and colur of ur  fields

[Chanty4u]

chk dis

[avinashelite]

Try like this >

1.Go to User Preference in the document setting

2.Click on Grid option in the design tab

3.right click on the object >format cell

4.Here you will get all the option to change the color

[anuradhaa]

Here i have use several dimensions and partial sums. That is why i coudn't get the colur variation. I have used custom format cell.

But can't seperate the raws

[Chanty4u]

can u shre ur sample qvw?

[anuradhaa]

I have marked that.

BUt no difference.

Here i have use several dimensions and partial sums. That is why i coudn't get the colur variation. I have used custom format cell.

But can't separate the raw

[avinashelite · Accepted solution]

Try like this :

Add this in the background colour area of the expressin, it will only format the total row

=if(rowno()=0 or isNull(rowno()),rgb(255,255,0),rgb(255,255,255))

Change the RGB() according to your required color format

[Chanty4u]

chk dis

[anuradhaa]

Qvw shared