How do I Not have Total Row Colored on pivot Table

[Keitaru]

Hi I'm trying to not have my Pivot table total row not be coloured but is not sure how to go about it.

What would I need to include to not have total Row colored?

if(wildmatch([TRO Aging],'a)*'),lightred(),
if(wildmatch([TRO Aging],'b)*'),rgb(255,190,0),lightgreen()))

[mfarsln]

Hi,

Add dimensionality() function to define totals color.

if(Dimensionality()<>0,  
  if(wildmatch([TRO Aging],'a)*'),lightred(),
  if(wildmatch([TRO Aging],'b)*'),rgb(255,190,0),lightgreen()))
)

[Keitaru]

If there is a total on the Column as well is there a way of removing its color as well?

[mfarsln · Accepted solution]

Hi,

Try this;

if(Dimensionality()<>0 and SecondaryDimensionality()<>0,  
  if(wildmatch([TRO Aging],'a)*'),lightred(),
  if(wildmatch([TRO Aging],'b)*'),rgb(255,190,0),lightgreen()))
)

[Keitaru]

That worked thanks.