Conditionally Color Partial Sum/Total Lines Only

[#1]

Is it possible to only conditionally color the partial sum or total lines? I only want to see the totals conditionally colored in a pivot table.

[Miguel_Angel_Baeyens · Accepted solution]

Hello,

I'd use dimensionality() function for that. Once you have created and placed your fields where you want to be, use in any expression and dimension -click on the "+" sign next to the dimension or expression name to expand and go to "Text Color"- something like

If(dimensionality() = 3, RGB(23, 23, 23), RGB(255, 0, 0))

Of course, colors can change, so dimensionality (depending on how many expressions do you have and where is set the total in your char).

[#3]

That did it. Thank you very much.