Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Color of total rows in pivot table

Is there a way to change backgroundcolor or text color to the total row in a pivot table?

14 Replies
Anonymous
Not applicable
Author

i've tried the "supress value when null" but it didn't work. It doesn't like the backgroundcolor expression. I'll keep look in to it... see what causes it.

Not applicable
Author

actually this worked for me. you just need to make sure you supress on all the field names on the left side of the pivot

Not applicable
Author

Hi Matt,

Thanks for your post

Does anyone know how to setup a different color depending to the total row,

Example in the screenshot below, I would like to color the line Max in Grey, but color the line Total Max in Blue.

I can't see any option like Current Dimension and Expression...

Thanks

Pierre

Custom Format Cell.jpg

Anonymous
Not applicable
Author

Hello,

Your solutions is good and i was looking for something like that only.

But can we make only the Main total in color.the only the Last row of Total not the Sub Total.

Is there any way to only color the Mi