Hi,

Here's what I need as the output for running total


Week   BU           Cumulative_Amount
1           AB         100
2          AC           230
3         AB           120
4         AB            0
5         AB            120

I would like to fill in the value of week 4 to 120 using a sql
statement.

Thoughts?

AJ

Using ranking functions in a subquery to feed a CLR function values in a specified order.
Challenging Query - Please Help
JOIN Question...
create a sp from query output
Combine records to calculate