# Rollup and how to display this "rolled up" information

**URL:** <https://community.glideapps.com/t/rollup-and-how-to-display-this-rolled-up-information/46864>\
**Category:** Ask for Help\
**Created:** [August 15, 2022, 8:03pm UTC](https://community.glideapps.com/t/rollup-and-how-to-display-this-rolled-up-information/46864 "2022-08-15T20:03:55Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![apaschea](https://avatars.discourse-cdn.com/v4/letter/a/ecc23a/32.png) [@apaschea](https://community.glideapps.com/u/apaschea)\
**Post date:** [August 15, 2022, 8:03pm UTC](https://community.glideapps.com/t/rollup-and-how-to-display-this-rolled-up-information/46864/1 "2022-08-15T20:03:55Z")

</div>

hard to explain in text. hopefully the video is clear. I would almost need “elements” in the builder to allow to count and sum things in the spreadsheet, instead of rolling up columns.

---

<div class="post-metadata">

**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:** [August 16, 2022, 1:03am UTC](https://community.glideapps.com/t/rollup-and-how-to-display-this-rolled-up-information/46864/2 "2022-08-16T01:03:44Z")

</div>

You’re sort of on the right track 😉

- Create a working table with one row for each of your sizes
- Create a relation joining each size to your other table that contains all the data
- Do your rollups through this relation. This will give you individual counts.
- And use this in your inline list

---

<div class="post-metadata">

**Author:** ![apaschea](https://avatars.discourse-cdn.com/v4/letter/a/ecc23a/32.png) [@apaschea](https://community.glideapps.com/u/apaschea)\
**Post date:** [August 16, 2022, 6:49pm UTC](https://community.glideapps.com/t/rollup-and-how-to-display-this-rolled-up-information/46864/3 "2022-08-16T18:49:47Z")

</div>

I think that makes sense in my head. I will try it out when I get home. Thank you!

What about row owners? A while back I tried something and I guess roll up will calculate everything (which makes sense). That inventory will have a city attached to it which will dictate what driver will get it.

I guess I would just make another column in that inventory spreadsheet for each driver, then add a filter for the city? Would prefer to have it automated so I wouldn’t have to add something manually every time a driver is added. Let me get the first part figured out then I will post a video about the row owners part.

Much appreciated as always!

---

<div class="post-metadata">

**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:** [August 17, 2022, 12:07am UTC](https://community.glideapps.com/t/rollup-and-how-to-display-this-rolled-up-information/46864/4 "2022-08-17T00:07:57Z")

</div>

It can take a while to get your head around how Row Owners works, and especially the implications for computed columns (at least it did for me). I think the penny finally dropped for me when I truly understood that:

- Row Owners prevents data from being downloaded to a users device
- Relations, rollups and all other computed columns are applied _AFTER_ all data is downloaded
- So all computed columns will work, but _ONLY_ with the data that actually exists on the device at the time

---

<div class="post-metadata">

**Author:** ![MattLB](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/mattlb/32/41284_2.png) [@MattLB](https://community.glideapps.com/u/MattLB)\
**Post date:** [August 28, 2022, 2:54pm UTC](https://community.glideapps.com/t/rollup-and-how-to-display-this-rolled-up-information/46864/5 "2022-08-28T14:54:19Z")

</div>

@david @Mark - @Darren_Murphy 's brief explanation needs to be added to the Docs. I have reviewed them again this morning and Darren’s succinct points would make this section so much easier to understand from a security and application design perspective - [Roles](https://www.glideapps.com/docs/reference/security-and-user-data/roles)

FWIW…
