title: Total Sum based on specific Date Range
body: <p>I ran a query that gave me a date range between 05/04/20 and 08/24/20</p>
  
  <p>Please see the sample Code: </p>
  
  <p>**</p>
  
  <pre><code>SELECT SM.GscSku, SM.LeadTime, SUM(FF.Total_Fcst) as Total_Fcst, CONVERT(varchar, DATE, 1) as Lead_Dates
      FROM GSC.SKU_Master as SM 
      JOIN GSC.Fact_Forecast as FF
      ON SM.GscSku = FF.GscSku
      WHERE SM.GscSku = 'WN80201ONE' and Date BETWEEN '05/04/20' and '08/24/20'
      GROUP BY SM.LeadTime, SM.GscSku, Date
  </code></pre>
  
  <p>**</p>
  
  <p>So far i got the result i want: </p>
  
  <p><a href="https://i.stack.imgur.com/LdDus.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/LdDus.png" alt="enter image description here"></a></p>
  
  <p>now the next step I want is to get the accumlative sum on the date range. the expected result I want is this </p>
  
  <p><a href="https://i.stack.imgur.com/w99jS.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/w99jS.png" alt="enter image description here"></a></p>