How can I change background color to a header in a Pivot Table?

[rociotrevial]

How can I change background color to a header in a Pivot Table, but only some columns header?

This columns are expressions and I need change background color in some columns header not in all.

For example, I have a Pivot Table like this:

Country	Sales	Cost
Mexico	345,456,890	123,678,543
USA	890,223,112	689,321,890
Japan	789,478,900	567,908,145

And I need distinct background color in the columns header of the expressions (Sales in Yellow and Cost in Green) , like this:

Country	Sales	Cost
Mexico	345,456,890	123,678,543
USA	890,223,112	689,321,890
Japan	789,478,900	567,908,145

How can I do it?

I need your help!!!

Thanks

[#2]

Hi,

As far as I know wyou can only achieve that using some visualization tricks.

Using the layer level you can  overlap the object and then usings their respective color properties, you can get an aproximate color custom solution of the pivot or straight tables headers.

Check the file attached and see if it satisfy your need

Cheers

[Sokkorn]

Hi rociotrevial,

This post http://community.qlik.com/message/261681 may do this job. Let me know once you tested it.

Regards,

Sokkorn

[Anonymous]

Hi Rocio,

This is ver y easy

Right click on chart -> "Custome format cell" and chnage the color for that particular cell BG.

Regards,

Nandha

[rociotrevial]

Hi Everyone,

The problem is when rightclicking and selecting "Custom format cell" the dropbox "Apply change to" only gives the option "All dimensions".

[rociotrevial]

Hi Everyone,

The problem is when rightclicking and selecting "Custom format cell" the dropbox "Apply change to" only gives the option "All dimensions".

[rociotrevial]

Hi Everyone,

The problem is when rightclicking and selecting "Custom format cell" the dropbox "Apply change to" only gives the option "All dimensions".

[rociotrevial]

Hi Everyone,

The problem is when rightclicking and selecting "Custom format cell" the dropbox "Apply change to" only gives the option "All dimensions".

[Anonymous]

Can you explain clearyl????

[er_mohit]

see the attached file hope it helps you

http://community.qlik.com/message/207492#207492