# Pivot Table in Glide

**URL:** <https://community.glideapps.com/t/pivot-table-in-glide/68108>\
**Category:** Ask for Help\
**Created:** [November 24, 2023, 12:44pm UTC](https://community.glideapps.com/t/pivot-table-in-glide/68108 "2023-11-24T12:44:36Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![sylvaingeron](https://avatars.discourse-cdn.com/v4/letter/s/f9ae1b/32.png) [@sylvaingeron](https://community.glideapps.com/u/sylvaingeron)\
**Post date:** [November 24, 2023, 12:44pm UTC](https://community.glideapps.com/t/pivot-table-in-glide/68108/1 "2023-11-24T12:44:36Z")

</div>

I have made a Glide table of Rooms with Surface and Level for each Room (in a given building).  
I want to calculate and show to the User the agregated Surface of all Rooms in a given Level.  
In excel, that would need a Pivot Table. How do you do the equivalent in Glide ?

Also, I want to make a new Table with rows update with the Levels as they get created or destroyed by the user. How do I do that ?

---

<div class="post-metadata">

**Author:** ![MegannLock](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/megannlock/32/19680_2.png) [@MegannLock](https://community.glideapps.com/u/MegannLock)\
**Post date:** [November 24, 2023, 1:06pm UTC](https://community.glideapps.com/t/pivot-table-in-glide/68108/2 "2023-11-24T13:06:39Z")

</div>

This is doable in Glide. Check out the docs for [Multiple Relations](https://www.glideapps.com/docs/automation/computed-columns/relations#multiple-relations) and [Rollup](https://www.glideapps.com/docs/automation/computed-columns/rollup-column) columns. It also would help to have a separate table that lists all the unique Levels! Maybe this could be the first step when users add new entries (select an existing level or add level first, then add room).

---

<div class="post-metadata">

**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\
**Post date:** [January 11, 2024, 5:58pm UTC](https://community.glideapps.com/t/pivot-table-in-glide/68108/3 "2024-01-11T17:58:51Z")

</div>

This is how I would do it: 1 table for the list of items, 1 helper table for the query column, choice components to write to the helper table (similar to choosing variables to roll up in a pivot table), a few user-specific columns associated to these choice components to filter the query column, rollups on the query column.

This approach is not at all as elegant or simple as pivot tables.

You can vote here:

> [@Pivot table](https://community.glideapps.com/t/pivot-table/69453):
>
> Hi would be good to have a pivot table component so we can process our data directly in our apps, and also the ability to create charts from pivot table data. Appsheet does that.