Scripts for Data Creation

Select
   Month_Id,
   TO_NUMBER(SUBSTR(month_id,5)) month_Num,
   Sales_Amount,
   SUM(Sales_Amount)
     OVER(ORDER BY month_id) sales_total
FROM
   Fact_Sales_Summary 
;

Running Total Query Output

This query created a running total from the first row value 
(201201) to last row value (201307) due to the exclusion of 
PARTITION BY SUBSTR(month_id,1,4) in the 
OVER(...) windowing function

Cummulative Total Sequential

Cummulative Total Yearly

Cummulative Total With Null Values

Cummulative Totals

Top




    69978