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 ; 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
69978