# Carry Over Sum by Date in Line Charts

**URL:** <https://community.amazonquick.com/t/carry-over-sum-by-date-in-line-charts/972>\
**Category:** Q&A\
**Tags:** charts, filters, calculations, quick-sight\
**Created:** [December 10, 2021, 6:43pm UTC](https://community.amazonquick.com/t/carry-over-sum-by-date-in-line-charts/972 "2021-12-10T18:43:39Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![next\_door\_bie](https://avatars.discourse-cdn.com/v4/letter/n/e495f1/32.png) [@next\_door\_bie](https://community.amazonquick.com/u/next_door_bie)\
**Post date:** [December 10, 2021, 6:43pm UTC](https://community.amazonquick.com/t/carry-over-sum-by-date-in-line-charts/972/1 "2021-12-10T18:43:39Z")

</div>

Hi folks, looking for some help with line charts. I want to display the sum of data points up to a date, by date. So let’s say I have one data point with date `2021-12-09` and two data points with date `2021-12-10` , my chart should display the value `1` for the first date and `3` for the second date. I am achieving this by using window functions in my query, however this won’t allow me to filter by other fields in quicksight. I am sure I am overthinking it and there should be an easier approach. Any thoughts?

---

<div class="post-metadata">

**Author:** ![Bchadha](https://avatars.discourse-cdn.com/v4/letter/b/ed655f/32.png) [@Bchadha](https://community.amazonquick.com/u/Bchadha)\
**Post date:** [January 26, 2022, 5:23pm UTC](https://community.amazonquick.com/t/carry-over-sum-by-date-in-line-charts/972/2 "2022-01-26T17:23:03Z")

</div>

It looks like you are trying to do a running sum. If yes, then you could try the RunningSum function which will allow the filters to be passed