set color for some of totals in pivot table

[#1]

Hello everyone,

I have a problem with totals. I have to close totals for one expression column. I have set same background color and text with

this formula ( =if(rowno()=0, rgb(200,200,200)) ). It workwd well for the last dimentions total but the first and second columns totals are still visible.

Does anyone have an idea?

[brenner_martina · Accepted solution]

Hi,

you can use Backgroundcolor and Textcolor in the expression by clicking the +-sign. Than use the expression:

If(Dimensionality()= 3,Grey())

Dimensionality() shows the number of the subtotal for that dimension

[#3]

Thank you Martina. I did not now this Dimensionality formula.