Skip to Main Content

Analytics Software

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!

Calculating cumulative quantity

426764Aug 3 2004 — edited Mar 24 2007
I'm trying to build a little data warehouse and i have a problem.
In one report among other things i need to calculate cumulative quantity from beginning of the year to current month.
It would be best to write a calculation to calculate this with analytic functions but i don't now how. I now how to calculate quantity for some previous month, but for period of time no.
Can somebody help me.
Thanks.

I have 9iR2 Enterprise Edition database and Discoverer 10g. If you need more information please say so.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 21 2007
Added on Aug 3 2004
6 comments
1,156 views