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




  1391