Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
sonikajain
Partner - Contributor
Partner - Contributor

color a specific row in pivot table

Dear all,

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

Sonika

4 Replies
jagan
Luminary Alumni
Luminary Alumni

Hi,

Check attached file for solution, hope it helps you.

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

Regards,

Jagan.

john_duffy
Partner - Creator III
Partner - Creator III

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
Partner - Creator III
Partner - Creator III

Hi Sonika.

Did these solutions resolve your issue?

John.

sonikajain
Partner - Contributor
Partner - Contributor
Author

not yet