Dynamic GETPIVOTDATA Formulas for Power Pivot – the PROPER way!

Microsoft Excel Tips and Tricks

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.

Credit MyOnlineTrainingHub