title: running total starting from a date column
body: <p>I'm trying to get a running total as of a date. This is the data I have</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Date</th>
  <th>transaction Amount</th>
  <th>End of Week Balance</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>jan 1</td>
  <td>5</td>
  <td>100</td>
  </tr>
  <tr>
  <td>jan 2</td>
  <td>3</td>
  <td>100</td>
  </tr>
  <tr>
  <td>jan 3</td>
  <td>4</td>
  <td>100</td>
  </tr>
  <tr>
  <td>jan 4</td>
  <td>3</td>
  <td>100</td>
  </tr>
  <tr>
  <td>jan 5</td>
  <td>1</td>
  <td>100</td>
  </tr>
  <tr>
  <td>jan 6</td>
  <td>3</td>
  <td>100</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>I would like to find out what the daily end balance is. My thought is to get a running total from each day to the end of the week and subtract it from the end of week balance, like below</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Date</th>
  <th>transaction Amount</th>
  <th>Running total</th>
  <th>End of Week Balance</th>
  <th>Balance - Running total</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>jan 1</td>
  <td>5</td>
  <td>19</td>
  <td>100</td>
  <td>86</td>
  </tr>
  <tr>
  <td>jan 2</td>
  <td>3</td>
  <td>14</td>
  <td>100</td>
  <td>89</td>
  </tr>
  <tr>
  <td>jan 3</td>
  <td>4</td>
  <td>11</td>
  <td>100</td>
  <td>93</td>
  </tr>
  <tr>
  <td>jan 4</td>
  <td>3</td>
  <td>7</td>
  <td>100</td>
  <td>96</td>
  </tr>
  <tr>
  <td>jan 5</td>
  <td>1</td>
  <td>4</td>
  <td>100</td>
  <td>97</td>
  </tr>
  <tr>
  <td>jan 6</td>
  <td>3</td>
  <td>3</td>
  <td>100</td>
  <td>100</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>I can use</p>
  <p><code>SUM(transactionAmount) OVER (Order by Date)</code></p>
  <p>to get a running total, is there a way to specify that I only want the total of transactions that have taken place after the date?</p>