How do I color a 'Totals' row in a pivot table? - QlikSense

[#1]

- QlikSense

- Pivot Table
- Styling/Formatting

- Totals

Hi,

How do I add a background color to my 'total' rows in a pivot table? I would like the rows to be more distinct.

TIA.

[shraddha_g · Accepted solution]

If(rowno() =0, rgb(), white())

Or

If(dimensionality()  =0,rgb(),white())

Put one of these expression in background color box of measure.

I hope it is helpful.

[#3]

Thank you for your answer for Shraddha.

Do you also know if we can color the Total title row as well?

TIA

[shraddha_g]

We cant color title row.

[heij1421]

If your total row is in the first column, then use

If(ColumnNo() =0, rgb(), white())

and you even can use nested ifs for more colors:

IF([Exec P&L Calculation]='c', RGB(210, 210, 210),
    IF(ColumnNo()=0, RGB(197,217,241)
       ))