how to format differently detail and total row

[#1]

hello to all, and sorry for my bad english.

i have a pivot table and in the detail row i format the background color, the font and so on, based on particular rule.

in the TOTAL row (and in the HEADER) i don't want to apply this rule, and i want use a fixed format of font, background color, ecc. ecc.

how can i make this ?

thanks in advance.

bye

[Gysbert_Wassenaar · Accepted solution]

Click on the + in front of the dimension or expression. There you can change the formatting. You can use the dimensionality() function the determine which level you're on. Try changing the expression for background color to If(dimensionality()=0,lightgreen()). This changes the background color of the overall total (=level 0) to lightgreen (as long as you enabled partial sums on the first dimension).

[#3]

Perfect !!!!!

thanks a lot.

bye

[#4]

Perfect !!!!!

thanks a lot.

bye