Leila is a genius, Lelia's videos are always so well explained and easy to follow, if ever I'm having problems she is always the first I go to. Thank you so much Leila!
I’ve recently starting using it. Finding it useful as an alternative to xlookuping large data sets. Improves performance by referencing a summarised version of it in a pivot tablle.
Hi Leila. Thank you for all your videos. Really great! I am wondering if there is an option you can add comments section to a pivot table other way then actually have special 'comments' column in the original data tab. I need to update my pivot with comments, but I couldn't find the option to do so. Please let me know if there is such option. Thank you
Is there a way to extract data from one table and insert in another? I have a table with internal invoice numbers that repeat multiple times to show sub contractor invoices. I like to extract each internal invoice and have them in a separate table where each will be unique. I hope this makes sense. As you can probably tell, I’m a novice.
Hi Leila, I download a bank statement daily and add information to it. With the information I have created an Analysis field so as to be able to identify types of expenditure and receipts during the year for each month. I created a pivot table that has the receipt and expenditure type in each row in one column, and Years in one row and Months in another in each column from left to right to the end of the data. With total for each were the intercept. I have been trying to add an opening and closing balance rows just below the Grand Totals in my Pivot Table. I ideally wanted it all auto update when I hit the refresh on the Pivot Table. I cannot get it to work unless I do it manually by pulling a column of data from left to right to reference the new data in the Pivot Table. I cannot seem to get the GETPIVOTDATA to work with the Receipt/Expenditure type with the Years and Months. Do you have any suggestions. If you would like to see my file and advise I am more that happy for you to take a look. I can change the data. Many thanks! Kind regards, Jason.
Hi Leila, Great video, as always! I have a question regarding the categories. You pointed out that they need to be visible in the Pivot Table. My question is if this also includes filters? I would prefer to have one category in the filter field, so I can better read the data in the Pivot Table itself. Tschüss!
You know what's sad? You can get 1080p videos from Udemy on RUclips but rarely on Udemy. You can choose 720p and lower on Udemy. If you want 1080p you need to choose AUTO and pray that Udemy website will be kind to you.
I am having trouble understanding the GETPIVOTDATA function. I just want the calculated sales total from my pivot table to display at the bottom so I can do My own formulas with it, however - my sheet is set like horizontally. I am probably missing a simple step- but I am not sure.
Good video.THX. QUESTION: I was hoping to find a way to simplify the copy/paste of a formula using the GetPivotData. Is there a way to include a formula in the GetPivot data function arguments? I was hoping to reference the first one (the header "title" with a cell reference ($A5 instead of "Sum of Revenue") Is this possible somehow??? I do know the other arguments (that refference files) can be changed by formula or cell refferences. But i struggle to remove the text of the "header" from the refference and make it automatic. THANK YOU!
You don't need to convert your data set to a Table using CTRL+T, you can just set the data source of the pivot table to be $A$D (all data in columns A through D)
Hi Leila,when using GETPIVOTDATA inside SUM to get sum of all row items it gives #REF! error if any of the row item is Null.is there a workaround for this(for eg:=SUM(GETPIVOTDATA("Qty",A3,"Product",{"Apple","Orange","Pineapple"},"Month","Jan")) here if for month Jan there is no value for Orange and Pineapple it gives #REF.
Hey, I have the data for which I wanted to create a inforgraphics.. In the data I have three columns:- area, No of days, total customer met. For example: New Delhi, 12, 50 It means in new Delhi in 12 days I met 50 people.. And my data goes on like this.. So how can I create a Inforgraph for this.. So that it is better understanding through chart. Pls help
Leila is a genius, Lelia's videos are always so well explained and easy to follow, if ever I'm having problems she is always the first I go to. Thank you so much Leila!
Awesome! I want my teachers and lecturers are just like her. Easy to understand :D
Life's good with LG.
Life's better with LG!
I learned a formula which I had never used in an effective. Thank you liela for uploading such video.
Thanks for this instructional video on Excel GetPivota Function. I've never used this functionality and going to work with it!
I’ve recently starting using it. Finding it useful as an alternative to xlookuping large data sets. Improves performance by referencing a summarised version of it in a pivot tablle.
Thank you so much Leila, that was lovely video, I have not used getpivot function before, but will from now on,
Viele liebe Grüsse
We're so glad you enjoyed the video!
Hello Leila,
Very simple explanation, i like the video. Nice explanation. Thank you soooo much
Leila! As always - great job! Thank you! 👏🌼🥇
Well done, Leila. Thank you.
Yes, we do use Getpivot a lot
Very nice! well explained. Clear and concise. TYSM
Thanks for the informative video.. Your videos are in general very professional and to the point just like how anyone would expect them to be.. 😊
Thank you so much I will use this functionality now
We're so glad you enjoyed the video!
very informative video
Thank you for comprihensive vedeo
She just the best!
I've been looking for this for awhile now.
Thank you! Much appreciated! 👍
Thank you Leila.
Thank you so much 👍
*Thanks.! I Purchased that in Udemy.*
very very useful, thank you very much!!!
Excellent
thank you so much for such a very good instructional video
Thank you for big help. from Korea :)
Hi Leila. Thank you for all your videos. Really great! I am wondering if there is an option you can add comments section to a pivot table other way then actually have special 'comments' column in the original data tab. I need to update my pivot with comments, but I couldn't find the option to do so. Please let me know if there is such option. Thank you
Awesome video
Very nice function. Thank you Madam.
Thanks for the New Idea.
We're so glad you found the video helpful!
Thanks😘
very useful , thanks
Thank you
Brilliant is there away of having the title on the chart dynamically linked to the slicer?
Is there a way to extract data from one table and insert in another? I have a table with internal invoice numbers that repeat multiple times to show sub contractor invoices. I like to extract each internal invoice and have them in a separate table where each will be unique. I hope this makes sense. As you can probably tell, I’m a novice.
Do you suggest using that instead of vlookups?
Thank you😊😊😊
thx so much
Wow !
show, parabens.
Att, Gledson Programador Excel VBA
Hi Leila, I download a bank statement daily and add information to it. With the information I have created an Analysis field so as to be able to identify types of expenditure and receipts during the year for each month. I created a pivot table that has the receipt and expenditure type in each row in one column, and Years in one row and Months in another in each column from left to right to the end of the data. With total for each were the intercept. I have been trying to add an opening and closing balance rows just below the Grand Totals in my Pivot Table. I ideally wanted it all auto update when I hit the refresh on the Pivot Table. I cannot get it to work unless I do it manually by pulling a column of data from left to right to reference the new data in the Pivot Table. I cannot seem to get the GETPIVOTDATA to work with the Receipt/Expenditure type with the Years and Months.
Do you have any suggestions. If you would like to see my file and advise I am more that happy for you to take a look. I can change the data.
Many thanks!
Kind regards,
Jason.
Yes, but why? I rejected GETPIVOTDATA function as unnecessary (compared to the SUMIFS function).
Hi Leila,
Great video, as always! I have a question regarding the categories. You pointed out that they need to be visible in the Pivot Table. My question is if this also includes filters? I would prefer to have one category in the filter field, so I can better read the data in the Pivot Table itself. Tschüss!
You know what's sad? You can get 1080p videos from Udemy on RUclips but rarely on Udemy. You can choose 720p and lower on Udemy. If you want 1080p you need to choose AUTO and pray that Udemy website will be kind to you.
no. not yet
Hi
i can not extract the dynamic part from pivot formula would you support me
شكرا
I have never used this before. Have no knowledge of it. Is it needed for the course.
Thank you :)
Great Video...What should we do to hide the original chart ("created with gaps").
Pemba, move the chart you want to show as part of a dashboard to a new sheet with the slicer.
Thanks
I am having trouble understanding the GETPIVOTDATA function. I just want the calculated sales total from my pivot table to display at the bottom so I can do My own formulas with it, however - my sheet is set like horizontally. I am probably missing a simple step- but I am not sure.
Hi Leila , How do we add dynamic referencing for date and years in getpivotdata formula .
Hey Leila,
Which course of yours has this video. I want to purchase the same.
Good video.THX.
QUESTION: I was hoping to find a way to simplify the copy/paste of a formula using the GetPivotData.
Is there a way to include a formula in the GetPivot data function arguments?
I was hoping to reference the first one (the header "title" with a cell reference ($A5 instead of "Sum of Revenue")
Is this possible somehow???
I do know the other arguments (that refference files) can be changed by formula or cell refferences. But i struggle to remove the text of the "header" from the refference and make it automatic.
THANK YOU!
how to filter descending order in getpivotdata function
You don't need to convert your data set to a Table using CTRL+T, you can just set the data source of the pivot table to be $A$D (all data in columns A through D)
I think you'll end up having blank values, which in some cases would need to be removed by deselecting "blank" in your pivot table filters.
Can you add subtitles in Russian in Turkish or Georgian? I bought the course but I don't understand the lessons :(
Can you focus ONLY on the GET DATA function? A simple how-to is all that's needed.
Hi Leila,when using GETPIVOTDATA inside SUM to get sum of all row items it gives #REF! error if any of the row item is Null.is there a workaround for this(for eg:=SUM(GETPIVOTDATA("Qty",A3,"Product",{"Apple","Orange","Pineapple"},"Month","Jan")) here if for month Jan there is no value for Orange and Pineapple it gives #REF.
Hey, I have the data for which I wanted to create a inforgraphics..
In the data I have three columns:-
area, No of days, total customer met.
For example: New Delhi, 12, 50
It means in new Delhi in 12 days I met 50 people..
And my data goes on like this..
So how can I create a Inforgraph for this..
So that it is better understanding through chart. Pls help
what the realation between exce l and bmp in picture or pixel in images
2:00
lol
Good information