# To make filter and sum amount **URL:** \ **Category:** Ask for Help\ **Created:** [July 18, 2022, 3:28am UTC](https://community.glideapps.com/t/to-make-filter-and-sum-amount/44690 "2022-07-18T03:28:55Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![paiboolk](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paiboolk/32/86903_2.png) [@paiboolk](https://community.glideapps.com/u/paiboolk)\ **Post date:** [July 18, 2022, 3:28am UTC](https://community.glideapps.com/t/to-make-filter-and-sum-amount/44690/1 "2022-07-18T03:28:55Z")
I want to make filter in Form and display sum amount of data at the bottom. How to do so? ---
**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:** [July 19, 2022, 1:27am UTC](https://community.glideapps.com/t/to-make-filter-and-sum-amount/44690/2 "2022-07-19T01:27:50Z")
Do you want to imitate the native buy button experience considering what you said in other threads? How will people pay for their order afterwards? ---
**Author:** ![paiboolk](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paiboolk/32/86903_2.png) [@paiboolk](https://community.glideapps.com/u/paiboolk)\ **Post date:** [July 19, 2022, 2:50am UTC](https://community.glideapps.com/t/to-make-filter-and-sum-amount/44690/3 "2022-07-19T02:50:46Z")
> [@ThinhDinh](#): > > buy button I tried to use buy button already. Unfortunately, I don’t stay in USA. ---
**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:** [July 19, 2022, 4:45am UTC](https://community.glideapps.com/t/to-make-filter-and-sum-amount/44690/4 "2022-07-19T04:45:19Z")
I mean are you trying to imitate a buy button experience? What have you configured so far (app screens & data tables)? ---
**Author:** ![Daniel\_Brassnyo](https://avatars.discourse-cdn.com/v4/letter/d/3d9bf3/32.png) [@Daniel\_Brassnyo](https://community.glideapps.com/u/Daniel_Brassnyo)\ **Post date:** [July 19, 2022, 10:14am UTC](https://community.glideapps.com/t/to-make-filter-and-sum-amount/44690/5 "2022-07-19T10:14:53Z")
> [@paiboolk](#): > > I tried to use buy button already. Unfortunately, I don’t stay in USA. Ah, so that’s why I couldn’t find the buy button. Is this a US feature only? ---
**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:** [July 19, 2022, 11:43am UTC](https://community.glideapps.com/t/to-make-filter-and-sum-amount/44690/6 "2022-07-19T11:43:22Z")
Stripe is available in many countries, but you must be a on a paid glide plan to use it. (Hungary is listed) > **[Available Countries: Find Stripe in Your Country | Stripe](https://stripe.com/global)** > > Find Stripe in your country for global support. See which countries Stripe supports and how to accept online payments worldwide. ---
**Author:** ![paiboolk](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paiboolk/32/86903_2.png) [@paiboolk](https://community.glideapps.com/u/paiboolk)\ **Post date:** [July 20, 2022, 5:47am UTC](https://community.glideapps.com/t/to-make-filter-and-sum-amount/44690/7 "2022-07-20T05:47:32Z")
By the way, I am here in Thailand. It’s excluded. ---
**Author:** ![paiboolk](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paiboolk/32/86903_2.png) [@paiboolk](https://community.glideapps.com/u/paiboolk)\ **Post date:** [July 20, 2022, 5:48am UTC](https://community.glideapps.com/t/to-make-filter-and-sum-amount/44690/8 "2022-07-20T05:48:33Z")
It’s just for some countries that Stripe exist. Anyway, can you share how to do sum amount at the bottom? ---
**Author:** ![paiboolk](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paiboolk/32/86903_2.png) [@paiboolk](https://community.glideapps.com/u/paiboolk)\ **Post date:** [July 20, 2022, 5:50am UTC](https://community.glideapps.com/t/to-make-filter-and-sum-amount/44690/9 "2022-07-20T05:50:55Z")
I tried to do a rollup but it summed all records. Not just my filtered data. Is it possible to lookup value by specific data like in Excel ? It will be helpful. ---
**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:** [July 20, 2022, 10:49am UTC](https://community.glideapps.com/t/to-make-filter-and-sum-amount/44690/10 "2022-07-20T10:49:24Z")
You will need either: - A relation to your data and then do the rollup using that relation. - Or create an IF column that returns the value you want to sum, based on similar conditions to your filter. Which method depends on how your filter is currently set up. ---
**Author:** ![paiboolk](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paiboolk/32/86903_2.png) [@paiboolk](https://community.glideapps.com/u/paiboolk)\ **Post date:** [July 21, 2022, 7:59am UTC](https://community.glideapps.com/t/to-make-filter-and-sum-amount/44690/11 "2022-07-21T07:59:18Z")
I am seeking for some methods similar to sumifs as in Excel. IF in this case is not possible. It will turn only that record. Relation should be worked, but didn’t. If Relation works, I can sum them by using rollup. ---
**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:** [July 21, 2022, 8:03am UTC](https://community.glideapps.com/t/to-make-filter-and-sum-amount/44690/12 "2022-07-21T08:03:13Z")
Either of the methods that Jeff mentioned will work if configured correctly. If you can share some sample data and explain how you currently have your filtering setup, we can provide some more specific guidance. ---
**Author:** ![paiboolk](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paiboolk/32/86903_2.png) [@paiboolk](https://community.glideapps.com/u/paiboolk)\ **Post date:** [July 21, 2022, 8:13am UTC](https://community.glideapps.com/t/to-make-filter-and-sum-amount/44690/13 "2022-07-21T08:13:54Z")
Great. Please visit my Google sheet with this link. > **[kaiklong\_a0001\_threetimes](https://docs.google.com/spreadsheets/d/1H4-B2wEIyrEicX9B9OuiotBKgbD9jcdqRh_wPK0spcs/edit?usp=sharing)** > > process > > สร้างข้อมูล,ให้สร้างไฟล์ Google Sheet > สร้าง store\_name,ข้อมูลลูกค้า > สร้าง main\_product,ข้อมููลสินค้าหลัก หาลิงค์รูป แล้วไปวางใน FB และนำลิงค์ออกมาจะใช้ได้ > สร้าง choices > สร้าง Transaction header ให้เหมือน Choice ที่ต้องการ, ระบุให้ตรงตาม Main... In transation sheet. There are so many records from customers. I record them line by line. And many details for any items. I use if-then-else to calculate amout in Glide. So, it can’t display in Google Sheet, but it displays in Glide sheet. Do you want to access my project ? ---
**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:** [July 21, 2022, 8:21am UTC](https://community.glideapps.com/t/to-make-filter-and-sum-amount/44690/14 "2022-07-21T08:21:54Z")
Can you show me how you are using that Transaction sheet in Glide (both in the data editor and in the app layout), and how you are applying filtering? Are you just using the native filtering with an Inline List? If you are, then it won’t be possible to have dynamic rollups. To get those, you need to implement custom filtering. Have a watch of the below video to get an idea how that can be done: > [@tornado Use Multiple Choice Components to Filter an Inline List](https://community.glideapps.com/t/use-multiple-choice-components-to-filter-an-inline-list/16932): > > [[Glide: Filter an Inline List with Choice Components] ](https://www.youtube.com/watch?v=NOYFsVUWQXw) Updated July 2022 > > > **Version 1** > > > > \https://www.youtube.com/watch?v=rtbFccDKuH0\ ---
**Author:** ![paiboolk](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paiboolk/32/86903_2.png) [@paiboolk](https://community.glideapps.com/u/paiboolk)\ **Post date:** [July 21, 2022, 8:26am UTC](https://community.glideapps.com/t/to-make-filter-and-sum-amount/44690/15 "2022-07-21T08:26:33Z")
Yes, I did native filtering with an Inline List. I will try as you mention and update you asap. Thanks a lot. ---
**Author:** ![paiboolk](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paiboolk/32/86903_2.png) [@paiboolk](https://community.glideapps.com/u/paiboolk)\ **Post date:** [July 21, 2022, 8:32am UTC](https://community.glideapps.com/t/to-make-filter-and-sum-amount/44690/16 "2022-07-21T08:32:10Z")
I got your point. The sample in your vdo clip linked if-then-else from UserProfile. But users in my app mostly are anonymous and I don’t want them to log in by using email. Please recommend solutions. Thanks a lot. ---
**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:** [July 21, 2022, 8:49am UTC](https://community.glideapps.com/t/to-make-filter-and-sum-amount/44690/17 "2022-07-21T08:49:08Z")
That’s okay. If your users are not logged in you can still use a similar method. But instead of creating the user specific columns in the user profiles table, you can create them in the Transactions table. ---
**Author:** ![paiboolk](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paiboolk/32/86903_2.png) [@paiboolk](https://community.glideapps.com/u/paiboolk)\ **Post date:** [July 21, 2022, 2:18pm UTC](https://community.glideapps.com/t/to-make-filter-and-sum-amount/44690/18 "2022-07-21T14:18:16Z")
Anyway, if there is no login. It still doesn’t work. And what will happen if there are some people try to use that filter at the same time? The rollup number still can be used? ---
**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:** [July 21, 2022, 2:20pm UTC](https://community.glideapps.com/t/to-make-filter-and-sum-amount/44690/19 "2022-07-21T14:20:25Z")
That’s what user specific columns are for. Every user (signed in or not) can update the same column in the same row without affecting other users. You don’t have to use the user profile. You can use any table with user specific columns to store filter values. ---
**Author:** ![paiboolk](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/paiboolk/32/86903_2.png) [@paiboolk](https://community.glideapps.com/u/paiboolk)\ **Post date:** [July 21, 2022, 2:47pm UTC](https://community.glideapps.com/t/to-make-filter-and-sum-amount/44690/20 "2022-07-21T14:47:03Z")
I totally agree that email login is so important. Unfortunately, my users are anonymous. Not possible to login by using email. [Next page](https://community.glideapps.com/t/to-make-filter-and-sum-amount/44690.md?page=2)