4 Replies Latest reply: Aug 6, 2018 1:45 AM by Rajesh Thakur

# Color by Background/ text Color expression

Hi,

I have a pivot table in which I calculated the measure using expression :

=Sum(NetSalesAmtUSD)/Before(Sum({<[Fiscal Year]>}NetSalesAmtUSD))-1

to get the growth rate. I want to color the text Red if below 20%, Amber if between 20%-60% and Green if above 60%.

But since this measure is not a column, I am unable to change the color of it using the regular color by expression function.

How can I achieve this?

I created a master item but of the above formula and called it % change in Sales but unable to get the right code.

• ###### Re: Color by Background/ text Color expression

Hi,

There is background and text color expression option available in measure of pivot chart. I guess, you can use if condition there.

Thanks,

RT

• ###### Re: Color by Background/ text Color expression

Hi,

Try as below -

If(

((Sum(NetSalesAmtUSD)/Before(Sum({<[Fiscal Year]>}NetSalesAmtUSD)))-1) < 0.2, rgb(229,122,122),

If(((Sum(NetSalesAmtUSD)/Before(Sum({<[Fiscal Year]>}NetSalesAmtUSD)))-1) > 0.2 and

((Sum(NetSalesAmtUSD)/Before(Sum({<[Fiscal Year]>}NetSalesAmtUSD)))-1) > .6, rgb(229,100,100), green()

)

)

Thanks,

RT

• ###### Re: Color by Background/ text Color expression

May be your expression like this:

=Sum(NetSalesAmtUSD)/Before(Sum({<[Fiscal Year]>}NetSalesAmtUSD))

And for Text Color change:

=If((Sum(NetSalesAmtUSD)/Before(Sum({<[Fiscal Year]>}NetSalesAmtUSD))) < 20%, rgb(229,122,122),

If((Sum(NetSalesAmtUSD)/Before(Sum({<[Fiscal Year]>}NetSalesAmtUSD))) > 20% and

(Sum(NetSalesAmtUSD)/Before(Sum({<[Fiscal Year]>}NetSalesAmtUSD))) > 60%, rgb(229,100,100), green())