# How would I add up all the balances and display that in the app? **URL:** \ **Category:** Ask for Help\ **Created:** [November 11, 2021, 4:45am UTC](https://community.glideapps.com/t/how-would-i-add-up-all-the-balances-and-display-that-in-the-app/34375 "2021-11-11T04:45:46Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![Kendall\_Hines](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kendall_hines/32/34228_2.png) [@Kendall\_Hines](https://community.glideapps.com/u/Kendall_Hines)\ **Post date:** [November 11, 2021, 4:45am UTC](https://community.glideapps.com/t/how-would-i-add-up-all-the-balances-and-display-that-in-the-app/34375/1 "2021-11-11T04:45:46Z")
![Screen Shot 2021-11-10 at 11.42.15 PM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/1/11625141e9dafb35e4865d58ab04e1b0b2099e8a.png) Ok so I have a sheet where the users have an associated company id and balance - after looking at this pic how would I get the sum balance for the company id 3 and display it in the app? Is that possible? ---
**Author:** ![Rosewebstudio](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/rosewebstudio/32/12261_2.png) [@Rosewebstudio](https://community.glideapps.com/u/Rosewebstudio)\ **Post date:** [November 11, 2021, 4:50am UTC](https://community.glideapps.com/t/how-would-i-add-up-all-the-balances-and-display-that-in-the-app/34375/2 "2021-11-11T04:50:54Z")
Have you tried rollup? > **[Rollup Column](https://docs.glideapps.com/all/reference/data-editor/computed-columns/rollup)** > > Calculate an entire column or relation ---
**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:** [November 11, 2021, 4:54am UTC](https://community.glideapps.com/t/how-would-i-add-up-all-the-balances-and-display-that-in-the-app/34375/3 "2021-11-11T04:54:43Z")
Assuming that you have another sheet that lists all of your companies, and that sheet also includes a company ID column: - Create a multi-relation from your Companies sheet, linking to this one and joining by Company ID - Then create a rollup through that relation, taking the sum of the “Cliki Balance” column. That will give you a sum for each company. ---
**Author:** ![Kendall\_Hines](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kendall_hines/32/34228_2.png) [@Kendall\_Hines](https://community.glideapps.com/u/Kendall_Hines)\ **Post date:** [November 11, 2021, 4:58am UTC](https://community.glideapps.com/t/how-would-i-add-up-all-the-balances-and-display-that-in-the-app/34375/4 "2021-11-11T04:58:40Z")
Indeed you are a mind reader 🙂 there is another sheet with all the comp id’s listed does it matter if this is glide pages and not an app or is it all the same? ---
**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:** [November 11, 2021, 5:00am UTC](https://community.glideapps.com/t/how-would-i-add-up-all-the-balances-and-display-that-in-the-app/34375/5 "2021-11-11T05:00:09Z")
> [@Kendall\_Hines](#): > > there is another sheet with all the comp id’s listed does it matter if this is glide pages and not an app or is it all the same? Don’t really understand your question. Google Sheets will appear as tables in the Glide Data Editor, and this is where you create these columns. Does that answer the question? oh, wait - you mean is there a difference in behaviour between a Glide App and Glide Pages? No, there isn’t. It’s the same for both in this case. ---
**Author:** ![Kendall\_Hines](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kendall_hines/32/34228_2.png) [@Kendall\_Hines](https://community.glideapps.com/u/Kendall_Hines)\ **Post date:** [November 11, 2021, 6:00pm UTC](https://community.glideapps.com/t/how-would-i-add-up-all-the-balances-and-display-that-in-the-app/34375/6 "2021-11-11T18:00:09Z")
I was able to actually accomplish this via a pivot table in google sheets pretty quickly - thx for your help 🙂 ---
**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:** [November 11, 2021, 11:43pm UTC](https://community.glideapps.com/t/how-would-i-add-up-all-the-balances-and-display-that-in-the-app/34375/7 "2021-11-11T23:43:45Z")
I think pivot tables do work for your case, but they will consume more rows. For my part, I always try to do as much as I can in Glide. Pivot tables mean more computing done in the Sheets as opposed to Glide, and it will decrease your app’s performance. Unless you have to see it in the Sheets, move things to Glide.