Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
=RangeSum(Above(Sum(Sold Quantity), 0, RowNo()))
=RangeSum(Above(Sum(Sold Quantity), 0, RowNo()))
Thanks .. it works .. will read the manual now about RangeSUM.
great..