4 Replies Latest reply on Jul 25, 2013 11:22 PM by buildstar

    Sum of Rows and display in new column


      Hi All,


      As shown in the image I need to arrive at values displayed in C column:


      In C column 1370311 value is arrived by adding A column from row 1 to 5

      The second value 1206853 is derived by adding A column from row 2 to 5


      Similarly rest of the values are computed.


      I also need to compute values for rows 7 -10 using same logic,


      I am trying and have been helped with this formula.However there is a variation in the values.


      WINDOW_SUM( sum(field), 0,LAST())


      How can I build a calculation the does this.