Cummulate

[#1]

Hello,

Every year, I keep the sales pro week in a table. Now i want  to see the total sales counting also the sales in the weeks before.

I have following table

Year

                     2012 2011

Week nr

         52     600 900

         51     400  500

etc.

Now i want to have

Week    2012 2011

      nr

        52 1000 1400

         51 400   500

etc.

How do i do this?

[#2]

try this

RangeSum(Above(sum(fieldname),0, rowno()))

[#3]

Hi,

Why don't you just use a pivot table?

Dim1=Year

Dim2=Week

Expression=Sum (amount)

and then activate on presentation tab the "show partial sums" on Dim2.

[#4]

Hi,

How can i create a pivot table. I create a table but i don't succeed.

[#5]

here i become 0 as output

[#6]

???

right clik on the sheet, new sheet object, chart and then select the pivot table.

[Anonymous]

try-

sum(aggr(rangesum(above(total sum({<Year=>}Amount),0,3)),Year)

[#8]

Thx! I succeeded. Problem was i had lowercase fieldname

[#9]

Hi VIshwarin,

now i have

52 200 200

51 400 600

but i want to have

52 200 600

51 400 400

how do i do that?