💫Use GETPIVOTDATA to extract information from a Pivot Table - Essential Pivot Table Skills☝️
HTML-код
- Опубликовано: 22 авг 2024
- 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
Woah! Need to backup a bit and learn Pivot Tables first? Check out my video ‘Pivot Tables in 15 minutes’. ➡️ ruclips.net/video/tIG-plVe_fM/видео.html
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.
That’s Awesome AJ! Glad I could help :)
This video has just helped me solve a problem ive been stuck on for 2 days. Thank you
Amazing!
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.
What a great lady teacher!
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.
LOVE IT!!!
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 !
thank you...really help
Great vid! But still wondering what's use case for GETPIVOTDATA? Since i can just create another pivot table or calculated field.
hi. The use case is demonstrated in the video. If you rearrange pivot fields the formulas break. GETPIVOTDATA prevents that.
@@cellmatestrainingThanks. I must have skipped a few seconds where I missed it.
Great
You are so great. Just curious, what’s your background? Why your teacher is such ?
I’ve been an IT Trainer for 20 years.
nice job. please put link excel file
You are awesome 🤍❤️🤍❤️
Thanks!