Microsoft Excel - GETPIVOTDATA Function

Learn about one of Excel's most powerful, versatile, yet misunderstood functions: the GETPIVOTDATA function. This function is IDEAL when creating dashboard reports that use Pivot Tables as an aggregation basis.

File download link:

00:28 Linking to other cells - 2 methods
01:26 Demonstrating the GETPIVOTDATA function's versatility
04:40 Real-life examples of use
05:09 Finding the Grand Total
05:41 Finding the total for a column field
06:33 Finding the total for a row field
06:55 Finding the total for a column/row combination
07:35 Using GETPIVOTDATA results in additional calculations
08:37 Building Dynamic GPT formulas

[sridharramadurai]

Sometimes despite knowing certain functions you don't make use of it. You need a spark. That's what your videos do. This is a nice way to have a single pivot table and have multiple output.

[IvanCortinas_ES]

Absolutely professional. As always, a pleasure to review your tutorials. The GETPIVOTDATA function is certainly very powerful. Thanks for sharing.

[shbuttone]

The storytelling is master class. Great tutorial. Loved it.

[VideoAndrega]

I am actually using it, but would not have explained it in such a clear and simple way.
I will refer to your video when explaining it to colleagues.
Thanks

[JM-mbtf]

I was one of the persons that hit Esc faster than lightning when I saw the nightmare of a formula I got - and if I don´t understand it - I don´t use it.
However, then BCTI came into my life and changed it 😂. Great video and even better explanation. I will throw away the Esc key now.

[ExcelWithChris]

Thanks my friend. Greetings from South Africa.

[jazzista]

Superb explanation Byron! I need to get back into using the getpivotdata function more often. Great refresher .

[arnyanderson]

Absolutely beautiful and fruitful
Great presentation
Hats off
Always waiting your new videos
Really today I was working with getpivotdata and seen your video now which really encourage me to step further

[thomas_didymus]

Thanks for the great video. I hope you do a follow up video showing a dashboard using these techniques, as mentioned in the closing minutes.

[ahmedshalaby]

This is my first video but your amazing

[nibgrahi]

Thanks a lot. Excellent way of explaining this. Now I am going to use it without getting scared.

Please similarly explain CUBEMEMBER and CUBEVALUE functions.

[MGAa]

Great intro video to "getpivotdata" function ... do you also use "cube" function for dashboards ?

[kkravch]

Great as usual, thanks!!! I played a bit with your file. Looks like we can always stay correct with the Total amount, but the reference to column and row values works as long as these values are part of the pivot table. We can safely have more dimension values in the pivot table than we evaluate, but cannot do the reverse. The underlying dataset is not helpful for the formula as the filtered values are not in the pivot table itself.

[robbe]

I have a question. In this example all formulas work fine.
But, what happens if we move the pivottable to somewhere else in the worksheet. Will everything still be working errorless?