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

    Color by Background/ text Color expression

    Mallika Mhapankar

      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.