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

[@cellmatestraining]

Woah! Need to backup a bit and learn Pivot Tables first? Check out my video ‘Pivot Tables in 15 minutes’. ➡️ kzbin.info/www/bejne/qnqqXqOii8qSnK8

[@eacequitableaccesscampaign7786]

What a great lady teacher!

[@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 :)

[@parminderkumar7612]

Wonderful you just solved my problem.thanks a lot

[@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!