Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
i want to give color to grand total in pivot table. [grand total text color] totals am getting bg color but grand total text colur still grey color i want that also to be yellow how to achieve this?
Can you try by enabling the grid layout (ctrl+G) and then right click on the total row -> 'custom format cell' ->background color....
Can you try by enabling the grid layout (ctrl+G) and then right click on the total row -> 'custom format cell' ->background color....
tried not working
its not taking for grand total rest values its coluring.
if do define your bg_Color (for each column) to
if (Dimensionality()=0, yellow())
only the total should appear in yellow
do you Need yellow also above?
in my Pivot table I get complet column colored by defining bg_Color = yellow()
No i want grand total row only full yellow data should be colured
so what can i use?
then just use
if (Dimensionality()=0, yellow())
that Colors only the last row (my example I only colored first column)
yeah i got it custom format cell
i need to select for all dimensions and expressions. then it worked . thanks for respose
Hi,
as Neelam Said
enabling the grid layout (ctrl+G) and then right click on the total row -> 'custom format cell' ->background color..fins
find the attached App.