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



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


      I created:



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




      if [Difference] <0 then "Down" ELSE




      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.