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

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

Glide table

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.

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

Likely you have exceeded the row limit for your plan.

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