# Dynamic big numbers based on data grid search bar filter
**URL:** https://community.glideapps.com/t/dynamic-big-numbers-based-on-data-grid-search-bar-filter/65660
**Category:** Ask for Help
**Created:** [September 1, 2023, 6:46am UTC](https://community.glideapps.com/t/dynamic-big-numbers-based-on-data-grid-search-bar-filter/65660 "2023-09-01T06:46:02Z")
**Posts on this page:** 11
**Page:** 1
### Author:  [@Chia](https://community.glideapps.com/u/Chia)
#### Post date: [September 1, 2023, 6:46am UTC](https://community.glideapps.com/t/dynamic-big-numbers-based-on-data-grid-search-bar-filter/65660/1 "2023-09-01T06:46:02Z")
Hi all, I have a data grid component with the built in search bar option on. On the bottom will be a few big numbers to show some relevant data.
Is there anyway to configure the big numbers to show on screen data after it is filtered? In example, the total unfiltered sales number is 14.5k and if I filter by product type pineapple, the sales count should be 2 and the sales total should be 2.5k.
Thanks in advance 😀
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [September 1, 2023, 8:49am UTC](https://community.glideapps.com/t/dynamic-big-numbers-based-on-data-grid-search-bar-filter/65660/2 "2023-09-01T08:49:30Z")
> [@Chia](#):
>
> Is there anyway to configure the big numbers to show on screen data after it is filtered?
Not with the built in search, no.
The only way to do that is to implement your own custom search/filter.
---
### Author:  [@FloMo](https://community.glideapps.com/u/FloMo)
#### Post date: [June 13, 2024, 5:03am UTC](https://community.glideapps.com/t/dynamic-big-numbers-based-on-data-grid-search-bar-filter/65660/3 "2024-06-13T05:03:07Z")
I can only use custom filters for collections, not for big number (or fields) components. Can you please share how I would do it for these components?
It looks like these components pull the first row from the table. Maybe there is a way to choose which row?
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [June 13, 2024, 5:14am UTC](https://community.glideapps.com/t/dynamic-big-numbers-based-on-data-grid-search-bar-filter/65660/4 "2024-06-13T05:14:59Z")
You can use custom filters for anything, including values for big number components. Custom filters set a value in a table. From there you can create relations or queries, and rollups on top of those relations or queries to get your final numbers for the big number components.
---
### Author:  [@FloMo](https://community.glideapps.com/u/FloMo)
#### Post date: [June 13, 2024, 5:23am UTC](https://community.glideapps.com/t/dynamic-big-numbers-based-on-data-grid-search-bar-filter/65660/5 "2024-06-13T05:23:29Z")
Ok. Thanx. I’ll follow the steps.
If you’ve come across a video that explains this I’d appreciate the headsup 👍🏿
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [June 13, 2024, 5:39am UTC](https://community.glideapps.com/t/dynamic-big-numbers-based-on-data-grid-search-bar-filter/65660/6 "2024-06-13T05:39:12Z")
I can’t think of any recent videos, but there several ways to do it. Start by writing those custom filter values to user specific columns in the table that is the source of your screen, or write then directly to the user profile row in the user table. Then take those values and build Query/Rollup Columns, or use single value columns to populate the custom filter values across all rows in your collection table and use an IF column to return certain values if they fit your filters, then Rollup the IF column. Lots of ways to get the same result.
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [June 13, 2024, 6:25am UTC](https://community.glideapps.com/t/dynamic-big-numbers-based-on-data-grid-search-bar-filter/65660/7 "2024-06-13T06:25:28Z")
> [@FloMo](#):
>
> If you’ve come across a video that explains this I’d appreciate the headsup
Here is one I made a while ago that includes applying filtered sums to Big Number components:
[ ](https://www.youtube.com/watch?v=jgMb5HsENEM)
---
### Author:  [@Himaladin](https://community.glideapps.com/u/Himaladin)
#### Post date: [June 13, 2024, 6:31am UTC](https://community.glideapps.com/t/dynamic-big-numbers-based-on-data-grid-search-bar-filter/65660/8 "2024-06-13T06:31:15Z")
It looks like you are switching to YouTuber. 😉
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [June 13, 2024, 6:32am UTC](https://community.glideapps.com/t/dynamic-big-numbers-based-on-data-grid-search-bar-filter/65660/9 "2024-06-13T06:32:35Z")
Yeah, the Loom links expire and break, so I’m starting to add them to Youtube when I can.
---
### Author:  [@Himaladin](https://community.glideapps.com/u/Himaladin)
#### Post date: [June 13, 2024, 6:34am UTC](https://community.glideapps.com/t/dynamic-big-numbers-based-on-data-grid-search-bar-filter/65660/10 "2024-06-13T06:34:08Z")
Good choice. YouTube is more accessible and has no limits.
---
### Author:  [@FloMo](https://community.glideapps.com/u/FloMo)
#### Post date: [June 15, 2024, 4:47am UTC](https://community.glideapps.com/t/dynamic-big-numbers-based-on-data-grid-search-bar-filter/65660/11 "2024-06-15T04:47:25Z")
This is SUPER! Thank you so much!