topic Re: How to highlight only first Totals row in the pivot table? in App Development

How to highlight only first Totals row in the pivot table?

Peony — Wed, 19 Nov 2025 17:09:29 GMT

Hi all.
Please advise whether there are any options to highlight, in colour, only the very top Totals in a pivot table.
I have a table like the one below and tried to solve this issue using the Dimensionality() function. For some reason, my formula does not work.
=If(Dimensionality() = 0,LightGray(), White())

Re: How to highlight only first Totals row in the pivot table?

marcus_sommer — Thu, 20 Nov 2025 06:49:06 GMT

It seems to be working - at least to Quarter - but you will probably need to set this customization to each column.

Re: How to highlight only first Totals row in the pivot table?

Nagaraju_KCS — Thu, 20 Nov 2025 06:50:54 GMT

That should work, you have to write same expression in all the Dimensions and Measures for Background color expression

=If(Dimensionality() = 0, RGB(200, 200, 200), White())

Re: How to highlight only first Totals row in the pivot table?

Peony — Thu, 20 Nov 2025 11:52:11 GMT

@Nagaraju_KCS you are right. Thank you.