# Total, Sum, Average etc

**URL:** https://community.glideapps.com/t/total-sum-average-etc/65067
**Category:** Ask for Help
**Created:** [August 15, 2023, 8:43pm UTC](https://community.glideapps.com/t/total-sum-average-etc/65067 "2023-08-15T20:43:16Z")
**Posts on this page:** 4
**Page:** 1

<div class="post-metadata">

### Author: ![mabulukatut](https://avatars.discourse-cdn.com/v4/letter/m/13edae/32.png) [@mabulukatut](https://community.glideapps.com/u/mabulukatut)
#### Post date: [August 15, 2023, 8:43pm UTC](https://community.glideapps.com/t/total-sum-average-etc/65067/1 "2023-08-15T20:43:16Z")

</div>

I can use rollup to make calculations, but I’m not sure how to use it to calculate ONLY the filtered/searched items on the front end UI using the native Glide search and filter.

It may not be a rollup solution, but does anyone know how to do this?

Thanks for your help!

---

<div class="post-metadata">

### Author: ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [August 16, 2023, 2:05am UTC](https://community.glideapps.com/t/total-sum-average-etc/65067/2 "2023-08-16T02:05:26Z")

</div>

> [@mabulukatut](#):
>
> I can use rollup to make calculations, but I’m not sure how to use it to calculate ONLY the filtered/searched items on the front end UI using the native Glide search and filter.

You can not reference the native search and filter values, so that’s a no.

---

<div class="post-metadata">

### Author: ![mabulukatut](https://avatars.discourse-cdn.com/v4/letter/m/13edae/32.png) [@mabulukatut](https://community.glideapps.com/u/mabulukatut)
#### Post date: [August 16, 2023, 2:18am UTC](https://community.glideapps.com/t/total-sum-average-etc/65067/3 "2023-08-16T02:18:45Z")

</div>

Thanks for the reply. Would you know of a workaround?? Platform this big and successful like Glide apps you would think basic functionality like this would be available. If you are dealing with at least 100 records would be nice to know some totals, counts, average for Stats purposes.

---

<div class="post-metadata">

### Author: ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)
#### Post date: [August 16, 2023, 11:54am UTC](https://community.glideapps.com/t/total-sum-average-etc/65067/4 "2023-08-16T11:54:18Z")

</div>

You could create your own custom filter with something like a choice component tied to a user specific column.  
Then create a relation from the users input and a rollup via that relation.

This approach will cost updates.