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

    Sum of Rows and display in new column

    buildstar

      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.

       

      Thanks