SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Accumulate Values Per month in a Financial Year

510257Mar 5 2009 — edited Mar 5 2009

Hello All,

I want to be able to accumulate all values in a financial year progressively each month and then begin again as a new financial year has been reached.
eg This is the table values

Month______ Value
May-08_____ 123
Jun-08______ 432
Jul-08_______12
Aug-08______76
Sep-08______122
Oct-08______433
Nov-08______165
Dec-08______232
Jan-09______211
Feb-09______365
Mar-09______122

I would like the following results

Month______ Value___YTD Total
May-08_____ 123_____123
Jun-08______ 432_____555
Jul-08_______12______12
Aug-08______76______88
Sep-08______122_____210
Oct-08______433_____643
Nov-08______165_____808
Dec-08______232_____1040
Jan-09______211_____1251
Feb-09______365_____1616
Mar-09______122_____1738

I tried to use the SUM(Values) over (order by Month) but not sure how to cater for the changes for each start in the financial year (July)

Hope you can help

Frank

Edited by: Species 5618 on Mar 6, 2009 10:51 AM

This post has been answered by Frank Kulash on Mar 5 2009

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 2 2009

Added on Mar 5 2009

3 comments

977 views