title: How to add values of weekend and holiday's to the previous working day
body: <p>I have to add weekend and holiday's value to the previous working day value so that weekend and holiday's should not display in the report but if we don't have previous working day we should simply skip the row as <code>2018-01-01</code> skipped in the below output </p>
  
  <pre><code>**DAYS      VALUE** 
  2018-01-01  10  Holiday-1
  2018-01-02  20  
  2018-01-03  30  
  2018-01-04  40  
  2018-01-05  50  
  2018-01-06  60  Saturday
  2018-01-07  70  Sunday
  2018-01-08  80  
  2018-01-09  90  
  2018-01-10  100 Holiday-2
  </code></pre>
  
  <p><strong>OUTPUT</strong>      </p>
  
  <pre><code>2018-01-02  20  
  2018-01-03  30  
  2018-01-04  40  
  2018-01-05  180 
  2018-01-08  80  
  2018-01-09  190 
  </code></pre>
  
  <p>I am trying with <code>LEAD, LAG, DATEDIFF</code> and in other ways but not getting any solution so please guys help he with this problem.</p>