# Pivot tables?

**URL:** <https://community.glideapps.com/t/pivot-tables/1795>\
**Category:** Ask for Help\
**Created:** [November 8, 2019, 2:48pm UTC](https://community.glideapps.com/t/pivot-tables/1795 "2019-11-08T14:48:13Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\
**Post date:** [November 8, 2019, 2:48pm UTC](https://community.glideapps.com/t/pivot-tables/1795/1 "2019-11-08T14:48:13Z")

</div>

Does anyone pull data from Pivot Tables into their apps? Is this possible?

I’m trying to create a “Stats” page that filters by user to show their monthly values nicely. Ideally, I’d also like to have a graphical display/chart.

---

<div class="post-metadata">

**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\
**Post date:** [November 8, 2019, 2:55pm UTC](https://community.glideapps.com/t/pivot-tables/1795/2 "2019-11-08T14:55:06Z")

</div>

I haven’t done it myself but if you create the table with a structure that has the column titles at row 1 I don’t see why it wouldn’t work.

---

<div class="post-metadata">

**Author:** ![George\_B](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/george_b/32/534_2.png) [@George\_B](https://community.glideapps.com/u/George_B)\
**Post date:** [November 8, 2019, 2:57pm UTC](https://community.glideapps.com/t/pivot-tables/1795/3 "2019-11-08T14:57:14Z")

</div>

I see you added the chart thing after my 1st answer. Yes there are a lot of people who have published these kinds of charts and then used them in a Glide app. Do a search here in the community. Others may comment with links to those discussions as well.

---

<div class="post-metadata">

**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\
**Post date:** [November 8, 2019, 3:06pm UTC](https://community.glideapps.com/t/pivot-tables/1795/4 "2019-11-08T15:06:29Z")

</div>

The issue I’m having is that the Pivot Table creates a 1st row “header” that doesn’t use the individual items I’m sorting by, but rather the column name in the other sheet (i.e. my Pivot Table is pulling in Activities and the number of times each user does each activity.). The Pivot table looks like this:

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/2X/5/520dd552d059327ac3bb10c378225f8c1956c020.png)

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [November 8, 2019, 3:28pm UTC](https://community.glideapps.com/t/pivot-tables/1795/5 "2019-11-08T15:28:54Z")

</div>

I would think some sort of combination of formulas, lookups, sums, queries etc. might get you there instead of using the built in pivot function. I found a couple links using queries to perform a pivot. If you need different headings, I’m sure you could duplicate the data into another sheet with custom headings and only pulling in the rows you need. Sorry I can’t be of more help, I don’t do much with pivot tables.

> <https://stackoverflow.com/questions/18181128/reproduce-pivot-table-with-query-formula>

> <https://webapps.stackexchange.com/questions/117061/how-to-aggregate-and-pivot-simultaneously-with-google-sheets-query>

---

<div class="post-metadata">

**Author:** ![kyleheney](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/kyleheney/32/41173_2.png) [@kyleheney](https://community.glideapps.com/u/kyleheney)\
**Post date:** [November 8, 2019, 3:30pm UTC](https://community.glideapps.com/t/pivot-tables/1795/6 "2019-11-08T15:30:35Z")

</div>

Thanks guys. I think you’re right in that the same can/should be accomplished differently when using Glide. Appreciate the input and links!