# Aggregation function is disabled when adding a second filter

**URL:** <https://community.amazonquick.com/t/aggregation-function-is-disabled-when-adding-a-second-filter/34932>\
**Category:** Q&A\
**Tags:** dashboard-embed, developer, quick-sight\
**Created:** [September 10, 2024, 7:02pm UTC](https://community.amazonquick.com/t/aggregation-function-is-disabled-when-adding-a-second-filter/34932 "2024-09-10T19:02:04Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![tal](https://avatars.discourse-cdn.com/v4/letter/t/54ee81/32.png) [@tal](https://community.amazonquick.com/u/tal)\
**Post date:** [September 10, 2024, 7:02pm UTC](https://community.amazonquick.com/t/aggregation-function-is-disabled-when-adding-a-second-filter/34932/1 "2024-09-10T19:02:04Z")

</div>

Hi:)  
I am trying to add a combination of filters by using the Add Filter Condition option.  
When i try to add the second filter it doesn’t let me choose aggregation function, see att. screenshot.  
When I try to choose the aggregated function and a date filter as the second it doesn’t let me either.  
What do you suggest for me to do?  
What i am trying to achieve is applying different filters on different months (aggregated groups). for example: filter all rows when Sep Volume\>2000 and August volume\<3000

Thank you

 ![Screenshot 2024-09-10 at 2.56.30 PM](https://d1wl4jav5dp96l.cloudfront.net/original/3X/3/a/3a139bd16c0289966965245c608aff1756e95c6e.png)

Tal

---

<div class="post-metadata">

**Author:** ![Brett](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/brett/32/36494_2.png) [@Brett](https://community.amazonquick.com/u/Brett)\
**Post date:** [September 11, 2024, 6:33pm UTC](https://community.amazonquick.com/t/aggregation-function-is-disabled-when-adding-a-second-filter/34932/2 "2024-09-11T18:33:35Z")

</div>

Hi @tal,  
This is currently a limitation with the current filtering options available in Quick Sight.  
One work around that could potentially work for your case; create a calculated field for each month so that you can set a filter on those instead.  
Your calculated field may look like this (September)

```auto
ifelse(
  extract('MM', {date_field}) = 9,
  sum({volume_field}),
  null
)

```

You can then follow same process for August. Then in your visual, you can setup a filter using these calculated fields instead and set the filtering option to your desired volume amount.

Let me know if this works for your case or if you have any additional questions!

---

<div class="post-metadata">

**Author:** ![tal](https://avatars.discourse-cdn.com/v4/letter/t/54ee81/32.png) [@tal](https://community.amazonquick.com/u/tal)\
**Post date:** [September 11, 2024, 7:41pm UTC](https://community.amazonquick.com/t/aggregation-function-is-disabled-when-adding-a-second-filter/34932/3 "2024-09-11T19:41:45Z")

</div>

I will try.  
Thank you for the creative thought:)

---

<div class="post-metadata">

**Author:** ![Brett](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/brett/32/36494_2.png) [@Brett](https://community.amazonquick.com/u/Brett)\
**Post date:** [September 23, 2024, 9:05pm UTC](https://community.amazonquick.com/t/aggregation-function-is-disabled-when-adding-a-second-filter/34932/4 "2024-09-23T21:05:00Z")

</div>

Hi @tal,  
Following up here to see if you had any additional questions?

If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic.

Thank you!

---

<div class="post-metadata">

**Author:** ![Brett](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/brett/32/36494_2.png) [@Brett](https://community.amazonquick.com/u/Brett)\
**Post date:** [September 26, 2024, 6:19pm UTC](https://community.amazonquick.com/t/aggregation-function-is-disabled-when-adding-a-second-filter/34932/5 "2024-09-26T18:19:37Z")

</div>

Hi @tal,  
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for any relevant information that may be needed.

Thank you!

---

<div class="post-metadata">

**Author:** ![tal](https://avatars.discourse-cdn.com/v4/letter/t/54ee81/32.png) [@tal](https://community.amazonquick.com/u/tal)\
**Post date:** [September 26, 2024, 7:21pm UTC](https://community.amazonquick.com/t/aggregation-function-is-disabled-when-adding-a-second-filter/34932/6 "2024-09-26T19:21:59Z")

</div>

> [@Brett](#):
>
> One work around that could potentially work for your case; create a calculated field for each month so that you can set a filter on those instead.

Thank you Brett.  
Your tip. was helpful. You can resolve this.