Dynamic GETPIVOTDATA Formulas for Power Pivot - the PROPER way! - My Online Training Hub
video description
Date: 2022-04-08
Related videos
Comments and reviews: 10
Star
I have been following your videos - Very helpful for me. I am a retired VP and manage my own stock portfolio. I have several sheets in my work book that use a column of stock symbols in separate tables. When I add or subtract a stock in say the master table I would like all of the tables to update with the new stock entry. I have tried many methods with no success - very frustrating for me. Note: I am not a pivot table user. Regards and thanks.
reply
I have been following your videos - Very helpful for me. I am a retired VP and manage my own stock portfolio. I have several sheets in my work book that use a column of stock symbols in separate tables. When I add or subtract a stock in say the master table I would like all of the tables to update with the new stock entry. I have tried many methods with no success - very frustrating for me. Note: I am not a pivot table user. Regards and thanks.
reply
Mihaela
Hi Mynda, I have a technical question :) and I hope you'll help me clear it out: could you please tell me what kind of audio setup you're using for recording your videos? Microphone, recorder, any other important ingredient for obtaining such a wonderful clarity of your recorded sound? Something specific to pay attention to, when going out shopping for this kind of equipment? Any advice on that? :) Thank you very much in advance!
reply
Hi Mynda, I have a technical question :) and I hope you'll help me clear it out: could you please tell me what kind of audio setup you're using for recording your videos? Microphone, recorder, any other important ingredient for obtaining such a wonderful clarity of your recorded sound? Something specific to pay attention to, when going out shopping for this kind of equipment? Any advice on that? :) Thank you very much in advance!
reply
Paul
Can you make a video that shows how to deal with balance sheet vs income statement variables in your data set? For example, let's say I have monthly data for both my IS and BS but I want to show total 2021 in a pivot table. I want the pivot table to add up all the IS variables, but I only want the BS variable to show the YE 21 ending value, not the sum of every balance from every month of the year. Is there a way to do that?
reply
Can you make a video that shows how to deal with balance sheet vs income statement variables in your data set? For example, let's say I have monthly data for both my IS and BS but I want to show total 2021 in a pivot table. I want the pivot table to add up all the IS variables, but I only want the BS variable to show the YE 21 ending value, not the sum of every balance from every month of the year. Is there a way to do that?
reply
MRUNAL
Hi
I have a requirement where in i have to enter getpivot formula multiple time for set of combination.
E.g.using the pivot shown in video
In cell i want to have data for 3 items from row and 3 items from columns but in one cell.
Is there any easy way. Since i have to enter i have to manual copy paste the formula in cell and then change the range to get correct data in particular cell. Its very tds.
reply
Hi
I have a requirement where in i have to enter getpivot formula multiple time for set of combination.
E.g.using the pivot shown in video
In cell i want to have data for 3 items from row and 3 items from columns but in one cell.
Is there any easy way. Since i have to enter i have to manual copy paste the formula in cell and then change the range to get correct data in particular cell. Its very tds.
reply
Gaijindesune
Great tips! Thank you for your clear explanations and the Canadian data shout-out!!
Just wanted to point out that Saskatchewan is misspelled. Right now it says -Saskachewan- (you are missing the -T-).
reply
Great tips! Thank you for your clear explanations and the Canadian data shout-out!!
Just wanted to point out that Saskatchewan is misspelled. Right now it says -Saskachewan- (you are missing the -T-).
reply
pxx
Merry Christmas Mynda, Phil & team. Thanks so much for the year's tips and all the work you do. I'm looking forward to more in the New Year and wish you all the best for the years ahead. Stay safe xx
reply
Merry Christmas Mynda, Phil & team. Thanks so much for the year's tips and all the work you do. I'm looking forward to more in the New Year and wish you all the best for the years ahead. Stay safe xx
reply
Robert
Great video and very helpful. I tend to avoid pivot tables but you videos are making me rethink that stance. Shout out for Canadian data. :-)
reply
Great video and very helpful. I tend to avoid pivot tables but you videos are making me rethink that stance. Shout out for Canadian data. :-)
reply
Vijay
Mynda, you can simplify complex things so easily! I had trouble understanding GETPIVOTDATA, but this tutorial made it clear. Thank you! --
reply
Mynda, you can simplify complex things so easily! I had trouble understanding GETPIVOTDATA, but this tutorial made it clear. Thank you! --
reply
Karim
Useful. I had actually switched this feature off as it now reads B3, B4 etc on = Cell ...as I didn't really appreciate this concept!
reply
Useful. I had actually switched this feature off as it now reads B3, B4 etc on = Cell ...as I didn't really appreciate this concept!
reply
jetglover
I love these tips... Things that seem almost obvious once they are explained so well, and you understand why... Thanks so much!
reply
I love these tips... Things that seem almost obvious once they are explained so well, and you understand why... Thanks so much!
reply
Add a review, comment
Other channel videos
