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

    Highlight Negative Variance in Cross Tab

    Shivi Bhatia



      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.




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


      Please suggest.