topic Re: How do I Not have Total Row Colored on pivot Table in App Development

How do I Not have Total Row Colored on pivot Table

Keitaru — Mon, 09 Mar 2020 03:36:35 GMT

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()))

Re: How do I Not have Total Row Colored on pivot Table

mfarsln — Mon, 09 Mar 2020 07:23:01 GMT

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())) )

Re: How do I Not have Total Row Colored on pivot Table

Keitaru — Tue, 10 Mar 2020 03:58:18 GMT

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

Re: How do I Not have Total Row Colored on pivot Table

mfarsln — Tue, 10 Mar 2020 06:43:25 GMT

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())) )

Re: How do I Not have Total Row Colored on pivot Table

Keitaru — Wed, 11 Mar 2020 06:27:42 GMT

That worked thanks.