# Aggregated calculated column values cannot be fetched

**URL:** <https://community.amazonquick.com/t/aggregated-calculated-column-values-cannot-be-fetched/49490>\
**Category:** Q&A\
**Tags:** admin, quick-sight\
**Created:** [August 29, 2025, 7:54am UTC](https://community.amazonquick.com/t/aggregated-calculated-column-values-cannot-be-fetched/49490 "2025-08-29T07:54:41Z")\
**Posts on this page:** 1\
**Showing post:** 2

<div class="post-metadata">

**Author:** ![Xclipse](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/xclipse/32/20455_2.png) [@Xclipse](https://community.amazonquick.com/u/Xclipse)\
**Post date:** [August 29, 2025, 11:20am UTC](https://community.amazonquick.com/t/aggregated-calculated-column-values-cannot-be-fetched/49490/2 "2025-08-29T11:20:59Z")

</div>

Hi @pantelis

Could you please try the below solution, this might be helpful for you.

> [@Issue adding a calculated field as a filter](https://community.amazonquick.com/t/issue-adding-a-calculated-field-as-a-filter/21623/3):
>
> Hi Erik! Thanks so much for your response. The calculated field is called “Best Seller?” and is as follows: ifelse({% of vendor revenue}\<0.05,“Low Seller”,{% of vendor revenue}\<0.3,“Medium Seller”,“Top Seller”) The % of vendor revenue is also a calculated field, as follows: sum({p\_rev\_t12w})/sumOver(sum({p\_rev\_t12w}),[{company\_vendor\_code},{marketplace\_id}]) These are normal metrics, not calculated fields. What I want to do is add the “Best Seller?” calculated field as a filter on top of t…

---

_[View the full topic](https://community.amazonquick.com/t/aggregated-calculated-column-values-cannot-be-fetched/49490)._