accumulation - running total

#1

SQL2K:

Month Qty
1/2006 10
2/2006 15
3/2006 5
......

I am looking for an accum_qty column that will give me the sum of previous
month:

Month Qty Accum_Qty
1/2006 10 10
2/2006 15 25
3/2006 5 30
.....

For the life of me, I can not seem to be able to find the correct syntax for
"accum_qty". Thanks much.

#2

search on the net for cumulative sum or pareto analysis.
but...
something like this could help:
sum( YTD(time.currentmember), measure.Qty)

"MJ" <MJ (AT) discussions (DOT) microsoft.com> wrote

Quote:

SQL2K:

Month Qty
1/2006 10
2/2006 15
3/2006 5
.....

I am looking for an accum_qty column that will give me the sum of previous
month:

Month Qty Accum_Qty
1/2006 10 10
2/2006 15 25
3/2006 5 30
....

For the life of me, I can not seem to be able to find the correct syntax
for
"accum_qty". Thanks much.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

accumulation - running total

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

accumulation - running total - 07-17-2006 , 05:07 PM

Re: accumulation - running total - 07-17-2006 , 05:50 PM