# Filtering By data field (not value)

**URL:** <https://community.amazonquick.com/t/filtering-by-data-field-not-value/2060>\
**Category:** Q&A\
**Tags:** analysis, filters, quick-sight\
**Created:** [March 4, 2022, 10:42am UTC](https://community.amazonquick.com/t/filtering-by-data-field-not-value/2060 "2022-03-04T10:42:14Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Gal](https://avatars.discourse-cdn.com/v4/letter/g/e480ec/32.png) [@Gal](https://community.amazonquick.com/u/Gal)\
**Post date:** [March 4, 2022, 10:42am UTC](https://community.amazonquick.com/t/filtering-by-data-field-not-value/2060/1 "2022-03-04T10:42:14Z")

</div>

Hi,  
is there a way to create a filter that changes the data field and not filter by data value.  
for example:

1. a graph showing avg sales per time - can i change the avg sale to avg revenue on the same visual?
2. the same example in a categorial field - change cars by color to cars by number of seats.

Thanks!

---

<div class="post-metadata">

**Author:** ![Koushik\_Muthanna](https://d2orw1595917va.cloudfront.net/user_avatar/community.amazonquick.com/koushik_muthanna/32/3290_2.png) [@Koushik\_Muthanna](https://community.amazonquick.com/u/Koushik_Muthanna)\
**Post date:** [March 4, 2022, 1:49pm UTC](https://community.amazonquick.com/t/filtering-by-data-field-not-value/2060/2 "2022-03-04T13:49:22Z")

</div>

Hi,

I believe what you are looking for is dynamic dimension and measures :  
[https://democentral.learnquicksight.online/#Dashboard-TipsAndTricks-Interactivity-Dynamic-Dimensions-and-Measures](https://democentral.learnquicksight.online/#Dashboard-TipsAndTricks-Interactivity-Dynamic-Dimensions-and-Measures)

Kind Regards,  
Koushik