Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
try this
RangeSum(Above(sum(fieldname),0, rowno()))
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.
Hi,
How can i create a pivot table. I create a table but i don't succeed.
here i become 0 as output
???
right clik on the sheet, new sheet object, chart and then select the pivot table.
try-
sum(aggr(rangesum(above(total sum({<Year=>}Amount),0,3)),Year)
Thx! I succeeded. Problem was i had lowercase fieldname
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?