# Pivot Tables
**URL:** https://community.glideapps.com/t/pivot-tables/78069
**Category:** Ask for Help
**Created:** [November 20, 2024, 5:05pm UTC](https://community.glideapps.com/t/pivot-tables/78069 "2024-11-20T17:05:59Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@CDP\_Beer](https://community.glideapps.com/u/CDP_Beer)
#### Post date: [November 20, 2024, 5:06pm UTC](https://community.glideapps.com/t/pivot-tables/78069/1 "2024-11-20T17:06:00Z")
Can Glide support pivot tables and that functionality in their GlideTables feature, or if I need pivot tables in my spreadsheets would I need to connect my GoogleSpreadsheet to GlideTables and have it be constantly updating?
---
### Author:  [@Hassan\_Nadeem](https://community.glideapps.com/u/Hassan_Nadeem)
#### Post date: [November 20, 2024, 6:24pm UTC](https://community.glideapps.com/t/pivot-tables/78069/2 "2024-11-20T18:24:59Z")
Although Pivot Tables aren’t directly available in Glide Tables, but we can create that functionality. What do you want to use Pivot Tables for?
---
### Author:  [@CDP\_Beer](https://community.glideapps.com/u/CDP_Beer)
#### Post date: [November 20, 2024, 7:40pm UTC](https://community.glideapps.com/t/pivot-tables/78069/3 "2024-11-20T19:40:33Z")
Functionality is pretty simple, would need to organize a data list that consists of items and scores, and find average scores for unique items and then rank them.
---
### Author:  [@gvalero](https://community.glideapps.com/u/gvalero)
#### Post date: [November 20, 2024, 8:12pm UTC](https://community.glideapps.com/t/pivot-tables/78069/4 "2024-11-20T20:12:29Z")
Hola!
I have some old APPs working with Pivot Tables from GS and those work well so far.
Try to replicate their functionality and make it simple in Glide is hard so, I left my PTs in my GS and read them manually when the APP is loaded or a button is clicked on.
Daily, one of my PTs receives 60-80 new values and the user opens my APP 5-8 times with no problem since 2022.
Saludos!
---
### Author:  [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)
#### Post date: [November 21, 2024, 1:08am UTC](https://community.glideapps.com/t/pivot-tables/78069/5 "2024-11-21T01:08:18Z")
> [@Displays unique data in another table, from which data is used for calculations](https://community.glideapps.com/t/displays-unique-data-in-another-table-from-which-data-is-used-for-calculations/78027/5):
>
> Do you care about what you’re supposed to display not having days when you don’t have any records? One of the methods would be: Create a query filtering the Tanggal column to be the same as current row \> Tanggal and Kode Mutasi equals to 2. Use a rollup to calculate the sum of the column you need. Add a single value column on top of the query to return the first rowID. On the front end, show records from this table with the rollup, filter by rowID equals to “first rowID”.
A variation of this would be applicable to you.
Basically you rollup on top of the relations to same-category items, and then find the first rowID from that same-category list to filter and only show that on the front end (so there are no duplicates).
---
### Author:  [@CDP\_Beer](https://community.glideapps.com/u/CDP_Beer)
#### Post date: [November 21, 2024, 7:19pm UTC](https://community.glideapps.com/t/pivot-tables/78069/6 "2024-11-21T19:19:01Z")
Thanks all for the help - I have figured out the ranking portion, but still struggling on how to find and compute the unique averages. Essentially I have 2 variables with different scores, and want to find the average score for each unique combination of variables.
Ive attached a photo, and basically want to compute a unique average for the AX and the CX combination, and so forth.
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [November 21, 2024, 8:18pm UTC](https://community.glideapps.com/t/pivot-tables/78069/7 "2024-11-21T20:18:56Z")
If you create a query column linking to all rows in the table to both variables in the same row, then you can do a Rollup on top of that query.