# Period over period + sum over with post\_agg\_filter feature request

**URL:** <https://community.amazonquick.com/t/period-over-period-sum-over-with-post-agg-filter-feature-request/15730>\
**Category:** Q&A\
**Tags:** feature-request, quick-sight\
**Created:** [July 14, 2023, 8:10am UTC](https://community.amazonquick.com/t/period-over-period-sum-over-with-post-agg-filter-feature-request/15730 "2023-07-14T08:10:44Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Krisztian\_Nemeth](https://avatars.discourse-cdn.com/v4/letter/k/46a35a/32.png) [@Krisztian\_Nemeth](https://community.amazonquick.com/u/Krisztian_Nemeth)\
**Post date:** [July 14, 2023, 8:10am UTC](https://community.amazonquick.com/t/period-over-period-sum-over-with-post-agg-filter-feature-request/15730/1 "2023-07-14T08:10:44Z")

</div>

Hi,

I was trying to build a YoY view on our dashboard but ran into a bit of a problem. The periodoverperiod calculation with sumOver works but as soon as I apply a filter it stops giving me results. (Drop down filters pinned to the top for users to easily change years, category etc.)

I would like to request a feature where we can have this exact combination of calculation but with an addedd post\_filter so when I apply filters I could still see the data.

This thread explains well what I have done but it excludes the filtering part.

> [@Previous Year Total values (at Quarterly Level) in Quicksight](https://community.amazonquick.com/t/previous-year-total-values-at-quarterly-level-in-quicksight/11689/9):
>
> @Max Yes, I created this calculation based on the formula you mentioned above but my ask is different. I want to create a calculated field under Total Units (PY) having a value of 334.1M against each record as per attached screenshot, the way I’ve 471.9M under Total Units (CY) against each record.

---

<div class="post-metadata">

**Author:** ![Max](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/max/32/2288_2.png) [@Max](https://community.amazonquick.com/u/Max)\
**Post date:** [July 14, 2023, 12:40pm UTC](https://community.amazonquick.com/t/period-over-period-sum-over-with-post-agg-filter-feature-request/15730/2 "2023-07-14T12:40:04Z")

</div>

Hi @Krisztian_Nemeth

I can mark this as a feature request.

I think this would be a really cool ability.

---

<div class="post-metadata">

**Author:** ![Max](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/max/32/2288_2.png) [@Max](https://community.amazonquick.com/u/Max)\
**Post date:** [July 21, 2023, 12:52pm UTC](https://community.amazonquick.com/t/period-over-period-sum-over-with-post-agg-filter-feature-request/15730/3 "2023-07-21T12:52:32Z")

</div>