color a specific row in pivot table

[sonikajain]

Dear all,

Please advise on coloring a specifc row named 'ALL' in a pivot table.

Sonika

[jagan]

Hi,

Check attached file for solution, hope it helps you.

Check Dimension and Expression Background color expression on expanding + icon.

Regards,

Jagan.

[john_duffy]

Hello.

I've used the background colour settings as mentioned above with the dimensionality function to colour specific rows.

In the attached example, I have changed the background to light red for all detail rows assoiciated with Dept IT - dimensionality() = 3.

I have also changed the background for sub totals at the Comp level to light green - dimensionality() = 1.

Hope this helps.

John.

[john_duffy]

Hi Sonika.

Did these solutions resolve your issue?

John.

[sonikajain]

not yet