Color to total

[soniasweety]

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?

[neelamsaroha157 · Accepted solution]

Can you try by enabling the grid layout (ctrl+G) and then right click on the total row -> 'custom format cell' ->background color....

[soniasweety]

tried not working

[soniasweety]

its not taking for grand total  rest values its coluring.

[Anonymous]

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?

[Anonymous]

in my Pivot table I get complet column colored by defining bg_Color = yellow()

[soniasweety]

No i want   grand total  row only full yellow   data should be colured

so what can i use?

[Anonymous]

then just use

if (Dimensionality()=0, yellow())

that Colors only the last row (my example I only colored first column)

[soniasweety]

yeah  i got it custom format cell

i need to select  for all dimensions and expressions.  then it worked .  thanks for respose

[Anonymous]

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.

• Color to total