2 Replies Latest reply on Oct 1, 2018 8:21 PM by Monisha Ramesh

    I would like arrows for my all my measure values

    Monisha Ramesh

      Please ignore the look of those letters A.B.C.D.E for each column.

      I placed this formula:

      if ZN(COUNT([worksheet id])) - LOOKUP(ZN(COUNT([worksheet id=1])), -1) > 0

      then 'increase'

      else if ZN(COUNT([worksheet id=1])) - LOOKUP(ZN(COUNT([worksheet id=1])), -1) < 0

      then 'decrease'

      else 'null or same'

      end end

      In my shape calculation but it seems to work only for the first 2 colums and not for the percentage differences. help?

       

      NOTE: My columns have only "Measure names" so I don't have multiple marks