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.
What a great tutorial. I’m that guy that cheats when referencing a pivot table. I only do simple calculations off of it but any time I saw that (previously) god forsaken function I immediately deleted the formula and used the cell reference. Thank you so so much for this. Making it dynamic sets it apart. I am always looking for ways to make formulas dynamic and I can be 100% sure I’ll be using this in my work very soon. You are awesome as always.
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
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.
Very useful real case scenarios, your videos are really wonderful. Appreciate your efforts. You should get Million subscribers soon. Normally I don't subscribe to any channels, but I have done it now. Thanks.
Thank you so much for your kind words and encouragement. I can only WISH for that many subs. I find it unlikely that will happen, but it's nice to dream. Cheers.
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
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.
You are correct. The function can only retrieve data if it exists in the Pivot Table. If you want to pull from the entire data set, you will either need to create 1 MASSIVE pivot table, or several smaller, topic-specific tables.
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.
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?
![Felix "Unfair" | [Stray Kids : SKZ-PLAYER]](http://i.ytimg.com/vi/Oswujxm2Ag0/mqdefault.jpg)
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.
@@sridharramadurai1206 That’s a great revelation! Thank you for sharing.
Seconded. I absolutely agree
What a great tutorial. I’m that guy that cheats when referencing a pivot table. I only do simple calculations off of it but any time I saw that (previously) god forsaken function I immediately deleted the formula and used the cell reference. Thank you so so much for this. Making it dynamic sets it apart. I am always looking for ways to make formulas dynamic and I can be 100% sure I’ll be using this in my work very soon. You are awesome as always.
EMBRACE the GETPIVOTDATA!!!! Glad to hear it's no longer your mortal enemy.
Absolutely professional. As always, a pleasure to review your tutorials. The GETPIVOTDATA function is certainly very powerful. Thanks for sharing.
@@IvanCortinas_ES So glad you agree. Hope it brings you much joy!!
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
Such a nice thing to say. Thank you for your support.
The storytelling is master class. Great tutorial. Loved it.
@@shbuttone Thank youuuuuuuu! We appreciate your kind words and support.
Superb explanation Byron! I need to get back into using the getpivotdata function more often. Great refresher .
@@jazzista1967 It is a great tool for feeding dashboards. Glad to bring it back into your toolkit. Cheers.
Have a great day. Your content is pure gold!
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.
So glad to hear you have embraced the Bounty Hunter! Now go conquer the World!
Very useful real case scenarios, your videos are really wonderful. Appreciate your efforts. You should get Million subscribers soon. Normally I don't subscribe to any channels, but I have done it now. Thanks.
Thank you so much for your kind words and encouragement. I can only WISH for that many subs. I find it unlikely that will happen, but it's nice to dream. Cheers.
@@bcti-bcti It will happen one day for sure. You keep rocking!!
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
Thank you sooooo much for your support. So glad this video helped push you to the next level. Cheers.
Thanks my friend. Greetings from South Africa.
@@ExcelWithChris Glad you enjoyed it. Hope you’re doing well.
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.
I'll put it on the list of upcoming videos. Thanks for the suggestion.
Awesome as always❤
Thank Youuuuuuuuuuu!
This is my first video but your amazing
@@ahmedshalaby9343 Wow! Welcome to the party. I hope you enjoy all the other videos on the channel. Thanks for your support.
Great info, thank you!
So glad you found it valuable. We appreciate your viewership.
Love it!!
@@IlaPatel811 So glad to hear. Thanks for watching.
Nice Video❤
@@Couriosity Thank you!
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.
You are correct. The function can only retrieve data if it exists in the Pivot Table. If you want to pull from the entire data set, you will either need to create 1 MASSIVE pivot table, or several smaller, topic-specific tables.
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.
I will add it to the topic list. Thanks for watching.
Great intro video to "getpivotdata" function ... do you also use "cube" function for dashboards ?
I don't use them much. My tactics differ, but I do see their value. Thanks for watching.
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?
If you move the pivot table, the reference to the pivot table will follow. All should be good.
mind blown
@@TheMarkGross Ha! Hope it didn’t hurt too badly.