💫Use GETPIVOTDATA to extract information from a Pivot Table - Essential Pivot Table Skills☝️

GETPIVOTDATA is the ‘Marmite’ of Excel functions: some people love it, some people hate it. Most people don’t understand how it works and why it is so useful.
GETPIVOTDATA is a setting that is turned on by default. When we try to link to a cell in a Pivot Table, the GETPIVOTDATA formula is automatically used.
GETPIVOTDATA is similar to linking to a cell except that the data we are linking to is in a Pivot Table and that Pivot Table has the potential to change layout. GETPIVOTDATA allows us to create a robust formula, that works even when Pivot Table fields are moved around.
In this video, we will take a detailed look at GETPIVOTDATA, run through an example of its use and discuss its advantages and disadvantages.
🔗LINKS to related videos
🔶Create a Basic Excel Pivot Table: • 🎉Create a Basic Pivot ...
🕒Excel Pivot Tables in 15 Minutes: • Excel Pivot Tables in ...
🗺️Create a Dynamic Map Chart: • 🗺️Create a DYNAMIC Map...
🤝Let's CONNECT on social:
➡️TikTok: / cellmates_
➡️Instagram: / cellmatestr. .
➡️LinkedIn: / deborahas. .
➡️Twitter: / cellmates_
➡️Facebook: / cellmates
#excel

[@cellmatestraining]

Woah! Need to backup a bit and learn Pivot Tables first? Check out my video ‘Pivot Tables in 15 minutes’. ➡️ th-cam.com/video/tIG-plVe_fM/w-d-xo.html

[@parminderkumar7612]

Wonderful you just solved my problem.thanks a lot

[@AJ_Aslam]

This is wonderful. I have to edit my report every month because of the pivot table change; no more of that anymore! I'll be using this technique. Thank you.

[@cellmatestraining]

That’s Awesome AJ! Glad I could help :)

[@eacequitableaccesscampaign7786]

What a great lady teacher!

[@daimzumara8115]

This video has just helped me solve a problem ive been stuck on for 2 days. Thank you

[@cellmatestraining]

Amazing!

[@andreausa123]

No wonder you are so cool. 😂 My background is accounting, and love to study these excel skills. I hope I can find a chance to go over all your teaching. Thanks again.

[@andersonc5311]

LOVE IT!!!

[@TriviaTrain-g5f]

thank you...really help

[@formtwo3017]

Very clear video. When I use =getpivotdata( to refer to the target cell in a pivot table which is on another sheet of the same excel file. However it only shows the first two syntax i.e., field and pivot table. There are no subsequent [field1, item1], [field2, item2] for me to work with. How to understand this? thanks.

[@youssef.elhraichi]

thanks for this video, it works with a simple Pivot Table, however, it doesn't work with the data model based pivot tables. Do you have any idea how to apply same logic to this kind of pivot tables ?
thanks again !

[@TheJoshtheboss]

Great vid! But still wondering what's use case for GETPIVOTDATA? Since i can just create another pivot table or calculated field.

[@cellmatestraining]

hi. The use case is demonstrated in the video. If you rearrange pivot fields the formulas break. GETPIVOTDATA prevents that.

[@TheJoshtheboss]

​@@cellmatestrainingThanks. I must have skipped a few seconds where I missed it.

[@shahidalikhan9503]

Great

[@andreausa123]

You are so great. Just curious, what’s your background? Why your teacher is such ?

[@cellmatestraining]

I’ve been an IT Trainer for 20 years.

[@ubaidillahmuhammad20]

nice job. please put link excel file

[@ahmedalloush1781]

You are awesome 🤍❤️🤍❤️

[@cellmatestraining]

Thanks!