Accumulated sum

[sculptorlv]

I have the following table:

Product Name          Sold Quantity     Sold Year

a                              50                         2014

b                              40                         2014

c                              90                         2014

a                              10                         2015

b                              20                         2015

c                              40                         2016

I need to do Pivot Table with two dimension: Product Name and Sol Year and two Expression:

Product Name     Year               Sold within year               Sold TILL year (accumulated sum)

a                         2014               50                                   50

a                         2015               10                                   60 (=50+10)

b                         2014                40                                  40

b                         2015                20                                   60 (=40+20)

c                         2016                40                                   40

I can't get right the second expression.. I tried:

SUM( TOTAL <Product Name>, Sold Quantity) ... but it doesn't work.

Please help with the correct expression for last column.

Thank you in advance.

[Chanty4u · Accepted solution]

=RangeSum(Above(Sum(Sold Quantity), 0, RowNo()))

• need to get the cummulative sum

[sculptorlv]

Thanks .. it works .. will read the manual now about RangeSUM.

[Chanty4u]

great..