Pivot table chart "show partial sums" total custom visual background

[matthewp]

In a pivot table chart, when you tick show partial sums you get a summed column that has a grey background (for the light theme) is there a way to customise this:

[Gysbert_Wassenaar · Accepted solution]

Click on the + in front of the expression on the Expression tab, select background color and enter an expression in the Definition field like =if(SecondaryDimensionality()=1, lightblue()). Depending on the number of dimensions you may have to use another value then 1. Experiment to see what works for your pivot table.

[matthewp]

excellent!

What about the top row..

[sunny_talwar]

You might also be able to play around with this using Custom Format Cell

Custom formatting table cells - The Qlik Fix! The Qlik Fix!‌

https://help.qlik.com/en-US/qlikview/12.0/Subsystems/Client/Content/Custom_Format_Cell_dialog.htm

[qlikviewforum]

Please help me out below

https://community.qlik.com/t5/New-to-QlikView/How-to-change-the-Background-color-of-Total-in-Pivot-t...