Discussion board where members can get started with Qlik Sense.
- Pivot Table- Styling/Formatting
How do I add a background color to my 'total' rows in a pivot table? I would like the rows to be more distinct.
If(rowno() =0, rgb(), white())
Put one of these expression in background color box of measure.
I hope it is helpful.
View solution in original post
Thank you for your answer for Shraddha.
Do you also know if we can color the Total title row as well?
We cant color title row.
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) ))