Get Data from your Pivot Table with the GETPIVOTDATA Function | Google Sheets

Learn how to use the GETPIVOTDATA function to extract the values from your pivot table. This tutorial will walk you through the steps to pull out the numbers you want, and the function will not break when you move the pivot table values around.

#googlesheets #pivottables #prolificoaktree

[toniwalker]

This helped with my EXACT problem I had for an HOUR! Now my Google Sheet Personal Financial Statement is complete for the new year 😊 thank you!

[wendymartinez]

Thanks for this video. I am learning Google Sheets and for me everything is totally new even I now excel. Pura Vida, from Costa Rica

[Ladderphobia]

Thank you for this video. It helped me with exactly what I needed.

[LeaugePlayer]

what if i just want to find total quantity of "online", regardless product?

[cyrusconfessions]

I have this pivot table same as yours but instead of price, the values are words. How can I get the value of the cell in the pivot data?
Thanks in advance

[davidmatten]

I am attempting to start from the most basic extract from a more elaborate Pivot Table that uses custom labels (as yours does), as well as calculated fields, etc. I am unable to get the most elementary form of GetPivotData to work:
=gpd("Minors", <ref>), where "Minors" is a relabeling of "SUM of Minors". This field is visible in the table, yet returns a REF error, saying "Field combination not found in pivot table for function GETPIVOTDATA".


Same behavior whether I reference the name of the field from a reference to the text in the table itself, or a string literal.


I am presenting my values as Rows rather than Columns. I am also applying various Filters.


By the documentation, this should just give an unqualified total, but gives an error instead. What is the issue?

[BrunoMartineledeCarvalho]

Hi, thanks for the video! I have a problem when a use dates as a pivot item. I already found a way (not a good one) to solve this problem: duplicate all date columns and set them as text, as well as the cell reference.
For example:
A1 = 01/10/2023 (mm/dd/yyyy format)
A2 = TEXT(A1, "#")
And them a use the cell A2 as reference.

Do you know any other way to do this?
Thanksss and regards from Brazil.

[AnshulMarele-gbaa]

How to return row data, not value column(s) data

[bitterboyblue]

What if you need to get the total? For example Total Fish Food in your sample pivot table?

[mattias]

Thanks for the video. However the way this functionality was created by Google is to me mind blowing how bad they made it. One would have thought that Google with all it´s resources and money would have come up with a better way of doing the GETPIVOT reference without having to type it manually (in Excel you just click anywhere in a pivot, the formula is created, and you just change the "FIELD" to cell references). And the fact that the formula is an actual cell reference (i.e. it still has to be within the actual pivot table range), that is just crazy in my opinion. Then what is the point having the GETPIVOT formula in the first place if it STILL has to be referred to e.g. $D$5 or similar? Google sheets still prove to me to be just a massive disappointment and like 20 years behind Excel in functionality.