# Dynamic Data

**URL:** <https://community.glideapps.com/t/dynamic-data/49095>\
**Category:** Ask for Help\
**Created:** [September 11, 2022, 3:37pm UTC](https://community.glideapps.com/t/dynamic-data/49095 "2022-09-11T15:37:47Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![agung\_Taufik](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agung_taufik/32/2589_2.png) [@agung\_Taufik](https://community.glideapps.com/u/agung_Taufik)\
**Post date:** [September 11, 2022, 3:37pm UTC](https://community.glideapps.com/t/dynamic-data/49095/1 "2022-09-11T15:37:48Z")

</div>

![Screenshot 2022-09-11 22.33.38](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/d/fd39cb9f67b36f7de5d6cb2ea3fb408a1bc966fa.png)

Hi all  
is there a way for “TOTAL PEMBELIAN” to be dynamic when I filter the data

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [September 11, 2022, 3:45pm UTC](https://community.glideapps.com/t/dynamic-data/49095/2 "2022-09-11T15:45:19Z")

</div>

How are you filtering the data? Essentially, you need to have the logic in your table, so you end up with an IF column that return only the filtered values. Then you can SUM that IF column.

---

<div class="post-metadata">

**Author:** ![agung\_Taufik](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/agung_taufik/32/2589_2.png) [@agung\_Taufik](https://community.glideapps.com/u/agung_Taufik)\
**Post date:** [September 12, 2022, 12:06am UTC](https://community.glideapps.com/t/dynamic-data/49095/3 "2022-09-12T00:06:07Z")

</div>

> [@Jeff\_Hager](#):
>
> How are you filtering the data?

I filter data by date, when I filter a specific date, I want “HARGA PRODUCT” to change the number dynamically.

 ![Screenshot 2022-09-12 07.02.04](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/0/4033be7bee4f5f3f5dd3d6e7721043523fb59216.png)

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [September 12, 2022, 12:45am UTC](https://community.glideapps.com/t/dynamic-data/49095/4 "2022-09-12T00:45:53Z")

</div>

It’s not possible to do this with the native filter, so as Jeff suggested you will need to build your own custom filter with associated logic in the data editor.

There are plenty of tutorials and guides around that show you how to do this. Search for “dynamic filter”

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [September 13, 2022, 4:44pm UTC](https://community.glideapps.com/t/dynamic-data/49095/5 "2022-09-13T16:44:29Z")

</div>

This topic was automatically closed 24 hours after the last reply. New replies are no longer allowed.