Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

pivot table-background color

Hello Team,

In straight table,we can change the bg color to pyjama green,pyjama red and pyjama blue.

likewise how to change it in pivot table??

Thanks in advance

4 Replies
robert_mika
Master III
Master III

In Style tab-->Current Style

See example

Not applicable
Author

Thanks for your reply.Due to personal edition cant open your qvw..

Could you please post a screenshot of it?

Not applicable
Author

PFACapture.JPG

Not applicable
Author

Thank you for your reply.

but my requirement is to show alternative colors.

while using bg color expression, it shows correct.

if(odd(F2),rgb(153,180,51),Green())

but when we expand this pivot table, it get mixed.

How to overcome this??

Capture143.PNG