# To sum filtered data for specific user **URL:** \ **Category:** Ask for Help\ **Created:** [August 22, 2020, 1:47pm UTC](https://community.glideapps.com/t/to-sum-filtered-data-for-specific-user/14405 "2020-08-22T13:47:13Z")\ **Posts on this page:** 9\ **Page:** 1
**Author:** ![Md\_Jakir\_Hossain](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/md_jakir_hossain/32/2861_2.png) [@Md\_Jakir\_Hossain](https://community.glideapps.com/u/Md_Jakir_Hossain)\ **Post date:** [August 22, 2020, 1:47pm UTC](https://community.glideapps.com/t/to-sum-filtered-data-for-specific-user/14405/1 "2020-08-22T13:47:13Z")
Hi, My app is regarding loan management for staff, where many staffs take loan from few bosses. Here is a screenshot. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/4/48c304c73a4e98aa8200d0239956181cfb24247a.png) My goal is to summarize total loan for specific applicant, total loan given by specific lender. Let kingvirus be applicant. Loan Summary for Kingvirus. Total Due:4000 Lender:Sk. Mamun Amount:1000 Lender:Jakir Amount:3000 Let Jakir be lender Lending summary for Jakir Total Amount:4500 Borrower:King Visus Amount:3000 Borrower:khanmda Amount:1000 Borrower:anupam Amount:500 I need your help. Thanks in advance. ---
**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 22, 2020, 1:52pm UTC](https://community.glideapps.com/t/to-sum-filtered-data-for-specific-user/14405/2 "2020-08-22T13:52:35Z")
You can make two relations for this. One for the applicant column, matching all applicant emails in the same column (multiple). Make a rollup over that column to sum the amount for displaying. Do the same for the lender column. ---
**Author:** ![Md\_Jakir\_Hossain](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/md_jakir_hossain/32/2861_2.png) [@Md\_Jakir\_Hossain](https://community.glideapps.com/u/Md_Jakir_Hossain)\ **Post date:** [August 22, 2020, 3:36pm UTC](https://community.glideapps.com/t/to-sum-filtered-data-for-specific-user/14405/3 "2020-08-22T15:36:29Z")
Applying relation for applicant column I can see all amount both Due and repaid. How to get only due amount. ---
**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 22, 2020, 3:41pm UTC](https://community.glideapps.com/t/to-sum-filtered-data-for-specific-user/14405/4 "2020-08-22T15:41:50Z")
Make a template joining the applicant email and the trans status, then make the relation & rollup on that column. ---
**Author:** ![Md\_Jakir\_Hossain](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/md_jakir_hossain/32/2861_2.png) [@Md\_Jakir\_Hossain](https://community.glideapps.com/u/Md_Jakir_Hossain)\ **Post date:** [August 22, 2020, 6:58pm UTC](https://community.glideapps.com/t/to-sum-filtered-data-for-specific-user/14405/5 "2020-08-22T18:58:21Z")
You gave me easiest solution in no time. Thanks a lot. ---
**Author:** ![gp9293](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gp9293/32/16743_2.png) [@gp9293](https://community.glideapps.com/u/gp9293)\ **Post date:** [February 3, 2021, 11:18pm UTC](https://community.glideapps.com/t/to-sum-filtered-data-for-specific-user/14405/6 "2021-02-03T23:18:07Z")
Similar problem for me. Want to count how many times a value shows up in a column. And want to do it in Glide not GS if possible. ---
**Author:** ![gp9293](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gp9293/32/16743_2.png) [@gp9293](https://community.glideapps.com/u/gp9293)\ **Post date:** [February 3, 2021, 11:35pm UTC](https://community.glideapps.com/t/to-sum-filtered-data-for-specific-user/14405/7 "2021-02-03T23:35:57Z")
Got it to work. Thank you ---
**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-sum-filtered-data-for-specific-user/14405/8 "2022-07-18T03:28:11Z")
I think I have similar problem as yours. I want to filter and sum amount of money in filtered data. How to do so? ---
**Author:** ![NoCodeAndy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nocodeandy/32/62530_2.png) [@NoCodeAndy](https://community.glideapps.com/u/NoCodeAndy)\ **Post date:** [January 17, 2024, 4:49pm UTC](https://community.glideapps.com/t/to-sum-filtered-data-for-specific-user/14405/10 "2024-01-17T16:49:25Z")