Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
rociotrevial
Creator
Creator

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

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:

CountrySalesCost
Mexico345,456,890123,678,543
USA890,223,112689,321,890
Japan789,478,900567,908,145

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

CountrySalesCost
Mexico345,456,890123,678,543
USA890,223,112689,321,890
Japan789,478,900567,908,145

How can I do it?

I need your help!!!

Thanks

10 Replies
Not applicable

hi try this

1.jpg

2. Right click on chart -> "Custom format cell"

2.jpg

hope this helps you.