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!
@notreallyhere11362 жыл бұрын
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.
@vita91972 жыл бұрын
Awesome! I want my teachers and lecturers are just like her. Easy to understand :D
@houstonvanhoy77672 жыл бұрын
Life's good with LG.
@vinod-fu5wn2 жыл бұрын
Hello Leila, Very simple explanation, i like the video. Nice explanation. Thank you soooo much
@yashsomaiya81415 жыл бұрын
I learned a formula which I had never used in an effective. Thank you liela for uploading such video.
@houstonvanhoy21982 жыл бұрын
Life's better with LG!
@winifredgiddings71545 жыл бұрын
Thanks for this instructional video on Excel GetPivota Function. I've never used this functionality and going to work with it!
@svetlanapokorna75802 жыл бұрын
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
@apwnew2 жыл бұрын
Leila! As always - great job! Thank you! 👏🌼🥇
@katerina64955 жыл бұрын
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
@udemy5 жыл бұрын
We're so glad you enjoyed the video!
@edrojano89024 жыл бұрын
Very nice! well explained. Clear and concise. TYSM
@faddtayo3 жыл бұрын
thank you so much for such a very good instructional video
@roberth.95584 жыл бұрын
Well done, Leila. Thank you.
@theflutemaya47374 жыл бұрын
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.. 😊
@samuelraj41345 жыл бұрын
Yes, we do use Getpivot a lot
@sivakumarbelamana19844 жыл бұрын
Very nice function. Thank you Madam.
@Muuip4 жыл бұрын
I've been looking for this for awhile now. Thank you! Much appreciated! 👍
@asifshauket5 жыл бұрын
Thank you so much I will use this functionality now
@udemy5 жыл бұрын
We're so glad you enjoyed the video!
@fe95232 жыл бұрын
very very useful, thank you very much!!!
@sedarathnadcd2 жыл бұрын
Thank you for comprihensive vedeo
@Success_Mantra824 жыл бұрын
*Thanks.! I Purchased that in Udemy.*
@shuska92474 жыл бұрын
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!
@seunghyunshin12865 жыл бұрын
Thank you for big help. from Korea :)
@ann-pl2st4 жыл бұрын
Thank you Leila.
@jasoncommins71972 жыл бұрын
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.
@patrickchileshe59844 жыл бұрын
She just the best!
@danielmathivathan73915 жыл бұрын
Brilliant is there away of having the title on the chart dynamically linked to the slicer?
@rosalynneal87615 жыл бұрын
I have never used this before. Have no knowledge of it. Is it needed for the course.
@zmalsabbagh Жыл бұрын
Thank you so much 👍
@Rajiblayek4 жыл бұрын
Hey Leila, Which course of yours has this video. I want to purchase the same.
@prathmesh__w2 жыл бұрын
very informative video
@toomtoom12122 жыл бұрын
Do you suggest using that instead of vlookups?
@mikeleblanc91035 ай бұрын
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.
@pembalama6775 жыл бұрын
Great Video...What should we do to hide the original chart ("created with gaps").
@brianhogan95635 жыл бұрын
Pemba, move the chart you want to show as part of a dashboard to a new sheet with the slicer.
@xBrugal3 жыл бұрын
Awesome video
@youarebest22 жыл бұрын
Excellent
@angelsapphire60884 жыл бұрын
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.
@jbseph11315 жыл бұрын
Thanks for the New Idea.
@udemy5 жыл бұрын
We're so glad you found the video helpful!
@sreejx5 жыл бұрын
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.
@karpin77473 жыл бұрын
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!
@ShivaSingh-vs4yv4 жыл бұрын
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
@melikadaneshjoo44624 жыл бұрын
very useful , thanks
@pralhaddhole52083 жыл бұрын
Thank you
@petr66172 жыл бұрын
Yes, but why? I rejected GETPIVOTDATA function as unnecessary (compared to the SUMIFS function).
@ravisuriya29704 жыл бұрын
Hi Leila , How do we add dynamic referencing for date and years in getpivotdata formula .
@jassem58553 жыл бұрын
Thanks😘
@Ahmed-mt1px2 жыл бұрын
Hi i can not extract the dynamic part from pivot formula would you support me
Can you add subtitles in Russian in Turkish or Georgian? I bought the course but I don't understand the lessons :(
@Saddam-Abdulameer4 жыл бұрын
شكرا
@Mishkafofer4 жыл бұрын
You know what's sad? You can get 1080p videos from Udemy on KZbin 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.
@ajmraghu26833 жыл бұрын
no. not yet
@pittedmetal5 жыл бұрын
Thank you :)
@belovedspear533 жыл бұрын
Can you focus ONLY on the GET DATA function? A simple how-to is all that's needed.
@brianpower63115 жыл бұрын
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)
@alexkim72703 жыл бұрын
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.
@chiomaizejimba85495 жыл бұрын
Thanks
@angekouakou7753 Жыл бұрын
Wow !
@fathyelsmadissy68315 жыл бұрын
what the realation between exce l and bmp in picture or pixel in images
@madhav7713 жыл бұрын
how to filter descending order in getpivotdata function