# Data not taking all row of my Pivot Table in my Google sheet

**URL:** <https://community.glideapps.com/t/data-not-taking-all-row-of-my-pivot-table-in-my-google-sheet/69985>\
**Category:** Ask for Help\
**Created:** [January 25, 2024, 3:46am UTC](https://community.glideapps.com/t/data-not-taking-all-row-of-my-pivot-table-in-my-google-sheet/69985 "2024-01-25T03:46:45Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Christopher\_Alade](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/christopher_alade/32/69867_2.png) [@Christopher\_Alade](https://community.glideapps.com/u/Christopher_Alade)\
**Post date:** [January 25, 2024, 3:46am UTC](https://community.glideapps.com/t/data-not-taking-all-row-of-my-pivot-table-in-my-google-sheet/69985/1 "2024-01-25T03:46:45Z")

</div>

I am having issues displaying all data in my pivot table in Glide, it is limiting the content to show only 10 row instead of 12 rows, please what can I do?

My pivot table  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/6/a/6ad220ac2927a502c09f1554837c98d649dc1790.png)

Glide table

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/d/ad67bda66c74be71116cb5afb8b934a294661855.png)

---

<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:** [January 25, 2024, 4:01am UTC](https://community.glideapps.com/t/data-not-taking-all-row-of-my-pivot-table-in-my-google-sheet/69985/2 "2024-01-25T04:01:47Z")

</div>

Have you considered creating that table in Glide instead of using a pivot table in a connected sheet?

All that is required is a Query column and a Rollup.

---

<div class="post-metadata">

**Author:** ![Christopher\_Alade](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/christopher_alade/32/69867_2.png) [@Christopher\_Alade](https://community.glideapps.com/u/Christopher_Alade)\
**Post date:** [January 25, 2024, 5:09am UTC](https://community.glideapps.com/t/data-not-taking-all-row-of-my-pivot-table-in-my-google-sheet/69985/3 "2024-01-25T05:09:07Z")

</div>

If I do that, it means I will have to update my data manually, instead of dynamically whenever I added new row to my googlesheet data

---

<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:** [January 25, 2024, 5:28am UTC](https://community.glideapps.com/t/data-not-taking-all-row-of-my-pivot-table-in-my-google-sheet/69985/4 "2024-01-25T05:28:04Z")

</div>

> [@Christopher\_Alade](#):
>
> show only 10 row instead

Likely you have exceeded the row limit for your plan.

> [@Christopher\_Alade](#):
>
> it means I will have to update my data manually,

Why would you have to update anything manually? Query and Rollup columns are dynamic based on the input data.