Dynamic GETPIVOTDATA Formulas for Power Pivot - the PROPER way!
The GETPIVOTDATA function is the secret weapon of the advanced PivotTable user. Unfortunately, most people are scared of it. In this video I'll show you how to use it properly.
Download the Excel file here: https://www.myonlinetraininghub.com/g...
0:00 Introduction
0:22 Turn on automatic GETPIVOTDATA formulas
1:08 How to tell if a PivotTable is Power Pivot or Regular Excel
1:20 GETPIVOTDATA for Power Pivot Syntax
3:09 Writing Dynamic GETPIVOTDATA Formulas
5:16 GETPIVOTDATA Limitations
Learn Power Pivot with Mynda: https://www.myonlinetraininghub.com/p...
Connect with Mynda on LinkedIn: / myndatreacy
