Background colours in pivot tables

[#1]

I have a pivot table where I want to highlight the "total" rows.

I was able to highlight the "Work Day" total by selecting the dimension AFTER Work Day in the Presentation tab, selecting sub-totals, and entering the expression "if(RowNo()=0,yellow())" as the background colour for that dimension.

However, when I try to set a background colour for the "Employee Total" by adding background colours to the "Work Day" dimension, I get all the dates in yellow, and when I try to set the background colour for "Name", nothing happens.

How can I set the background colour for the "Employee total" sub-total?

[sunny_talwar]

Use the concept for dimensionality() in your background color expression to achieve this. Something like this:

If(Dimensionality() = 0, Blue())

Please note: Actually dimensionality will depend on which level of subtotal are your trying to color.

Update: Attaching a sample

HTH

Best,

Sunny

[PrashantSangle · Accepted solution]

Hi,

Right click on Total Cell-> custom Format Cell->select Background Color.

Regards