4 Replies Latest reply: Mar 5, 2015 2:26 PM by Marco Puccetti RSS

    Rangesum Before

    Marco Puccetti

      Can you explain me the use of rangesum(before()) statement in a pivot table like this:

       

      Tabella
      Data olderData newer
      ValuePerc
      numberPercent of increment
      ValuePerc
      NumberPercent of increment

       

      with this formula:

       

      (sum(N_REC)-rangesum(before(sum(N_REC),1,1)))

       

      The formula would compute the increment percentage of the number value related to the Data newer Value number, but i can't understand the meaning.

       

      Can

       

      Thank you