7 Replies Latest reply on Sep 27, 2017 11:26 AM by John Hobby

    Add Trend Arrow in the rightmost column

    Mark Schukas

      I would like to add a Trend Arrow in the rightmost column (up/down) of the last two months

       

      Ex.

         Category, May Sales, June Sales, July Sales, Trend of last two months (June and July)

       

      I created:

       

      //Difference

      ZN(SUM([Value Measure])) - LOOKUP(ZN(SUM([Value Measure])), -1)

       

      and

      //Arrow

      if [Difference] <0 then "Down" ELSE

      "Up"

      END

       

      this works on a separate worksheet, but when I try to add to an existing worksheet (layout above), I can't just get the one column

      (to the right of just the last two months)...?

       

      ???

       

      thank you.