Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear all,
Please advise on coloring a specifc row named 'ALL' in a pivot table.
Sonika
Hi,
Check attached file for solution, hope it helps you.
Check Dimension and Expression Background color expression on expanding + icon.
Regards,
Jagan.
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.
Hi Sonika.
Did these solutions resolve your issue?
John.
not yet