Can we colour total and subtotal font in Pivote table

[P_Kale]

Hi ,

Is it possible to colour the total & sub-total in pivote table. Something like given in below excel.

Thanks in Advance

@sunny_talwar 

@swuehl 

@Anil_Babu_Samineni 

@marcus_sommer 

[marcus_sommer · Accepted solution]

In general yes. In QlikView you may chose an appropriate design within the tab Design and/or using attribute-expressions - totals could be queried with dimensionality() - and/or the custom cell-format. I assume in Sense are similar features available.

[P_Kale]

Thanks Marcus

Yes. I am able to achieve to colour Total Row. But unable to achieve to colour sub-total.

I am using below expression.

If(Dimensionality() = 0, RGB(0,0,225),
if(SecondaryDimensionality()=1,RGB(128,0,0)))

[P_Kale]

Hi I am able to achieve through below expression Thanks.

If(Dimensionality() = 0, RGB(0,0,225),
if(Dimensionality() =1 ,RGB(128,0,0)))