3 Replies Latest reply on Nov 28, 2016 9:37 AM by Shivi Bhatia

    Highlight Negative Variance in Cross Tab

    Shivi Bhatia

      Hi,

       

      I have built a cross tab analysis.

       

      I am doing a difference of budget for Q1 and Q2. Have created a third column which does the difference and shows values as either negative or positive.

       

      Is there a way where i can only color only the 3rd rows as red or green. I have done a calculation if [Difference]>= 0 THEN "Yes" ELSE "No" END. But this colors all 3 rows.

       

      So,

       

      1. How can i only color the last row
      2. How can i only show negative values

       

      Please suggest.