2 Replies Latest reply on Nov 24, 2016 7:22 AM by Amit Narkar

    Text color of multiple measures based on previous month value and current month value comparision

    Meghana Kedari

      Hi All,

       

      I have a requirement wherein I have to show Green color for the text if the current month value is greater than the previous month value and red if it is less than previous month. The challenge that I face here  are  -

      1)  I have multiple measures  - The calculated field works perfectly if I consider any one of the measures but starts showing wrong colors as soon as I add more than one measure.

      2) Calculated field dragged into color shelf fills up all columns though the calculation is written only for one or two columns.

       

      Please let me know if we can color only few measures in the table and no color for the rest based on current and previous month values. Any help will be greatly appreciated