Pivot Table Show Value as : % Parent Total, % Parent Row Total, Difference From,Running Total, Rank

Подписаться 149 тыс.

Просмотров 68 тыс.

50% 1

Pivot Table Show Value as : % Parent Total, % Parent Row Total, Difference From,Running Total, Rank
1. How to calculate % Parent Total
2. How to calculate % Parent Row Total
3. How to calculate Difference From
4. How to calculate % Difference From
5. Rank Smallest to largest and largest to smallest
Download the Assignment Master Practice Folder here (All Playlist Example at one place)
drive.google.com/drive/folder...
(Playlist Folder-Excel Pivot Tables-Show Value As1.xlsx)
Website - "www.innozant.com"
Let's Connect:
Instagram ► / innozantoffi. .
Facebook ► / innozant
Twitter ► / innozant
Linkedin ► / inno. .
#pivottable #showvalueas#Innozant #exceltuorial #excelpivottables #misinterviewquestions

Опубликовано:

9 сен 2020

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 151

@monikaagrawal5535 Год назад

Hello sir, you have uploaded the excel series 2 years ago, one day i just had on question and i googles so your video came up from that day i am learning all the excel series u posted from the video and its really amazing . I am blessed that i got the prefect teacher like you who teaches very well to students. I really want that you see my this comment. Thank you so much sir..hope in this small world, we can meet some day.

@Innozant Год назад

Wow.. Really means a lot to me Monika,pinned your comment ❤️😊👍 Have a wonderful career ahead,Will surely meet.Keep Growing 👍

@arvindtech408 2 месяца назад

Sir ye Sab Sikhane k Bhoot Sare RU-vid wale 20000 Tak charge kar rhe hai Aur aap free mein itna best sikha rhe hai Thanks Sir

@Innozant 2 месяца назад

Keep learning and Keep growing

@arvindtech408 2 месяца назад

@@Innozant sir ek video is par banaiye agar koi data mein look-up value mein duplicate value ho to vlookup konsa value lega....aur hme dono chahiye to kaise lenge

@Manishkumar-bw9nf 3 года назад

You teach very well sir. Thank you for your valuable time that you are giving to us through RU-vid. keep teach to us 🙏

@forgotten_friend5406 2 года назад

I have seen many videos on pivot table but Your teaching style is very good. Thanks for sir.

@MDYOUSUF-tl8sk 2 года назад

Excellent video on this topic. Thanks a lot

@deeptisharma4272 2 года назад

You are one of the best excel teachers I came across on youtube. Thank you

@Innozant 2 года назад

Thanks Deepti for your valuable appreciation, Kindly start your learning journey in sequence step by step from Basic excel to advanced (Playlist link available in video description) Never stop learning.Keeo Learning Keep exploring ❤️

@sandeepaswal8944 3 года назад

Many thanks Sir. Glad i started learning from you and now i would not like to learn from anyone else. Your voice modulation and expertise is second to none. Thank you for such great instructions

@Innozant 3 года назад

Thanks Sandeep for such a lovely appreciation.😊🙏

@sudhishjaiswal520 Год назад

sir ap ka video best h hum sabhi ke liye

@1gopalakrishnarao 3 года назад

Excellent. You are explaining the most important trick/tip for analyzing the data, which is very vital. Really very much useful. Doing great a job indeed.

@Innozant 3 года назад

Thanks Gopala Krishna Sir,Good Night🙏♥️

@1gopalakrishnarao 3 года назад

@@Innozant Very good night. Thank you. You are having a bright future in this field. All the very best.

@MdIlyasShaikh 3 года назад

Really nice explanation. I think it's the 1st video of pivot on the youtube platform.

@Innozant 3 года назад

Thanks IIyas Shaikh Sahab🙏♥️for such a lovely comment.Happy Learning dear🙏♥️

@kapilkashyap7026 3 года назад

Tnx sir your channel is best for advanced excel . Your method is different from other. I like your channel so much. Pls continue for us.

@Innozant 3 года назад

Thanks Kapil ji.. Really means a lot to me..Happy learning dear

@thangaveluraj5366 2 года назад

Your presentations are extraordinary,, congratulations and thanks

@Innozant 2 года назад

Thanks dear..God bless you.❤️

@HabibUllah-cw7do 2 года назад

Again, Salute to you

@MrJafferyable Год назад

Excellent. Thanks a million ton for this time saving tricks. I've always failed to do these %age, but this video is absolutely crisp and clear and very much useful.

@Innozant Год назад

Thanks Syed..Have. A wonderful career ahead

@MrJafferyable Год назад

@@Innozant Thank you.

@MrJafferyable Год назад

I've have a Pivot Table where I want to calculate % of Discount against Sales w.r.t. each Customer. The Customer Name is in ROWS field, Sales Value as well as Discount is in VALUES field. Therefore the information that pivot is showing is: Party-wise Sales and Discount. Now, how can I calculate Discount as a percentage of Sales??? Please help!

@nkparis Год назад

Nicely explained 😌

@sandeepshakya4069 Год назад

Excellent

@rjraviraftarup7553 3 года назад

Excellent 👍👍

@dreamyworldpositivevibes7277 2 года назад

Thankuu sir I am so grateful I found your channel this is very useful

@Innozant 2 года назад

❤️👍

@sandeepsomanath7643 3 года назад

Ur explanation is superb, ur smiling face is very nice 👍

@Innozant 3 года назад

Thanks Sandeep ji for your valuable appreciation ❤️🙏

@hemantgusain1260 3 года назад

Thanks you sir for this video, I was waiting this video for a long time.

@Innozant 3 года назад

Ok Hemant,Yes I aware with that.Hope it helps..Will try to cover all aspect of show value as..Explore and learn...😊🙏

@shrikantbadge3978 6 месяцев назад

Complicated but beautiful and when explained by Dilip sir, it is more beautiful.

@Innozant 6 месяцев назад

Thanks

@jaydippandamahapatra3304 2 года назад

Extraordinary

@umairmughal7546 2 года назад

Sir good job 👍👍👍

@sawaimalhi8439 3 года назад

bahot he maza ah aya sch main sir thank you sir aaap ka bahot bahot ehsan hai

@Innozant 3 года назад

Thanks Sawai..

@hemgandhi8087 2 года назад

Thankx

@kinghundred 3 года назад

very useful sir

@Vavgamefmindia 10 месяцев назад

Very good

@javedshaikh7550 Год назад

Hi , let me tell you, you are doing wonderful job by giving a super best example for excel in different chapters, 2. The way you speak hindi language, while teaching the class, is very clear and easy,to understand, this is really help a lot bez you are capturing every single set and option which available in excel, And today iam giving you this comment bez of your PIVOT, SHOW AS VALUE, VEDIO, Is just amazing you clear my doubts. Keep posting like this kind of vedio which empower the skill, I would like to see you next vedio on index match, Thanks a lot I will like and sub, for your channel

@Innozant Год назад

Thanks dear .. Really means a lot to me..Keep learning..Keep exploring ❤️

@javedshaikh7550 Год назад

@Innozant there are many more facilitors to teach excel, iam watching all thise vedio from last 3 to 4 year but I never like or subrices thier channel. But for you I have done this in 20 min vedio of your Thanks buddy, keep going

@Crocodile_Gaming.2002 Год назад

Sir, mere muh mai sabdh khatam ho gaye. Aapki tarif ke liye. Sabdh bhi kam padh gaye sir aapki tarif ke liye. Thank you sir itni jyada acchi teaching ke liye. Or sir meri English speaking thodi kamjor hai. Sir iska bhi khuch upaye batayiye.

@DineshSingh-lc5gk Год назад

Thanks Sir

@rohitacharya2101 3 года назад

U did the postmortem of pivot table 😂😂....enjoyed learning boss👍🙏

@Innozant 3 года назад

Hahahaha.. Thanks Rohit..Hope These in sequence playlist course help you in your professional career

@RohitKumar-cc7zi 3 года назад

Owesom, you have very good way to teach us, owesom video

@Innozant 3 года назад

Thanks Rohit Ji for such a valuable feedback..Will try to make awesome content for all of you dear.🙏♥️

@alikhankhan1350 2 года назад

@@Innozant boss I nee your email address I am big fan

@jamalibrahim3229 3 года назад

sir, thanks for teaching ms excel, i have very good commad on ms excel and i want to become a data analyst , please makes some basic videos of sql

@Innozant 3 года назад

Thanks Jamal sahab..Soon you may able to watch power seires and sql analytics videos.

@hsgusain2054 Год назад

thanks sir

@bhoopendraraghav9781 3 года назад

Wow amazing thanks sir

@Innozant 3 года назад

Thanks Bhoopendra for wonderful feedback..tc..gn

@hirenkothari5778 2 года назад

Sir, Agar maire pass 2 pivot table hai(jan se dec month ka data)and muje usme compare karke ek hi sath mai difference find karna ho to kaise karna hai.please bataye.muje doubt hai ki aapne aage ki ek video mai bataya tha lekin muje yad nahi hai..this formula most useful for office work at present.please help as fast as possible.

@fl_d1043 2 года назад

Can we use this tools to analyse Economics Marginal cost and total cost concept ? By the way .....you r god to us

@swaroops5973 Год назад

Hello Sir, Very good explanation. I just have a question regarding running total. Actually I want to carry running total values to next year based grouped by months and year. How to do that using pivot table? Thanks for insights :)

@dipeshshah2925 3 года назад

Superb Sir very very helpful

@Innozant 3 года назад

Thanks Dipesh Ji.

@satishojha6240 3 года назад

This is real video of pivot table with deep knowledge thanks sir.but sir I have question which type of report can use percentage pivot table.Good night have a sweet dream.

@Innozant 3 года назад

Thanks Satish Ji..Report is based on. Requirement that comes from management.Its not fixed,We need to calculate based on that

@satishojha6240 3 года назад

@@Innozant ok sir

@anujdairyhajipur5229 Год назад

I HAVE A PIVOT TABLE. IN THIS TABLE IN THE TOP ROW & COLUMN 1 IS THE DATE RANGE AND I WANT TO USE THIS DATE RANGE COMMAND WITH VBA USER FORM. WHEN IN USER FORM I CHANGE THE DATE AND CLICK ON SHOW IN USER FORM THEN PIVOT TABLE TOP ROW & COLUMN 1 IS THE DATE RANGE IS AUTOMATIC CHANGE AND UPDATE WITH DATE DATA. IF IS IT POSSIBLE ??? PLEASE RESPONSE ME. AND MAKE A VIDEO ON IT. THANKS (AMARENDRA KUMAR)

@keshav9460 10 месяцев назад

nice

@KuldeepSingh-nq1vi 2 года назад

Well done💯👍

@Innozant 2 года назад

Thanks Kuldeep Ji

@Mu00lia Год назад

love you guy

@Innozant Год назад

Thanks dear

@ArvindSingh-wp8hw Год назад

I have seen more than 100 videos, and Now I have reached my final decision that I'll switch my carrier in DATA Analyst, but I'm afraid as My communications skill is not good so somewhere I have difficulty growing because of communication.

@Innozant Год назад

That's great If you already know your weak point then why not start working on that ,It will take some time that's not a big problem .

@kiranghadi7088 2 года назад

Sir if I am filter the pivot the % are change please explain how we can stop this

@bishtlokesh1297 3 года назад

Awsome 🖤💐💐

@Innozant 3 года назад

Thanks Lokesh ji

@bhajanmarg35 13 дней назад

Sir mere laptop me ye option hi nhi dikha rha h please batao sir kya new version me kahi or se hoga kya ?🙏🏻

@PavanKumar-cm2sz 3 года назад

u r gr8 sir

@Innozant 3 года назад

Thanks Pavan ..hv a nice day

@shiashots110 3 года назад

Brilliant

@Innozant 3 года назад

Thanks dear🙏❤️

@meta7480 2 года назад

Sir muje ye PTA krna h ki 25year to 45 year ke under kitne candidate h

@sadashivkage3133 6 месяцев назад

🙏🙏

@sandeshpayer650 6 месяцев назад

Brokerage+ reward/70%. (If ke formule me Sum ka aur umesme persentage nikala sakte hai kya)

@TheVaibhav1982 2 года назад

How use var, char etc in "value of" in pivot table.

@gauravbhatia7987 3 года назад

Thnq sir

@Innozant 3 года назад

❤️♥️👍🙏

@sameerwagh409 Год назад

Sir vba code with excle table with filter /slicer and send selected table to email??

@umairzahid3743 3 года назад

Amazing sir

@Innozant 3 года назад

Thanks Umair Sahab❤🙏

@Funnydogandanimalplay 2 года назад

Good vidio hai sir ji

@Innozant 2 года назад

Thanks dear

@jaimishra425 2 года назад

Sir how to show the growth of% in pivot table.

@meditationmusic6482 3 года назад

So nice Sir ji 😄

@Innozant 3 года назад

Thanks dear Saboj ji❤️🙏

@GoQuick100 2 года назад

Thank you very much for this wonderful video 🙏, Sir MS OFFICE 2019 कैसे download kare please Help Me 🙏

@puspakumarale714 2 года назад

how to get this date please provide data

@rjraviraftarup7553 3 года назад

⭐⭐⭐⭐⭐

@tjr1421 Год назад

Sir excel 2007 me data model ka optn kaha hai?

@bishtlokesh1297 3 года назад

Sir please power pivort ke video laye

@dharmendarrana4191 3 года назад

Dear Sir, If an employees calls taken 3100 in a month then how much his money. How to calculate incentive by Excel Formala ? This is incentive format.., Slab Calls From - To Incentive/Calls Slab 1 1841 - 2024 2.50₹ Slab 2 2025 - 2116 3.50₹ Slab 3 2117 - 2207 4.50₹ Slab 4 2208 - 2300 5.50₹ Slab 5 2300 - Above 10₹ Answer sir ......

@Altaf_Alam Год назад

Bahot badhiya sir ❤️ Sir power bi bhi advance sikhayege ? Excel ke jaisa 😊

@Innozant Год назад

Yes dear

@Altaf_Alam Год назад

@@Innozant love u my dear sir ❤️😀

@khalidmajeed2886 2 года назад

respected sir where we use these % in our daily routine work. what is called in our daily routine office work.

@Innozant 2 года назад

Khalid sahab..Use % of feature when you want the show your data filed value as percentage of grand to total or coln or row or parent total of your choice

@abhijitdey1819 2 года назад

Value me 3 coloum se jyada nehi aa raha hai sir. Apka kaise aa raha hai sir

@GreendaySid96 2 года назад

Where's the link for the previous video?

@Innozant 2 года назад

Kindly watch the assignment link in video description -assigment master 2nd link

@sudiptamanna4195 2 года назад

distinct count not available Excel-2010

@khalidmajeed2886 2 года назад

sir why and where we use data model check.

@Innozant 2 года назад

Data model is use to establish the relationship between multiple tables

@vikramkumar-ch2gw 3 года назад

Sir how can see financial year wise

@Innozant 3 года назад

In pivot or using funcation you want

@nishikant2354 2 года назад

Sir I want to join online paid-up class. Do u provide certificate for that courses..

@Innozant 2 года назад

Ye we are running Live classroom session (Offline /online)) For more info You may whatsap/call us. (Contact nom available in latsest video intro or visit Innozant website)

@nishikant2354 2 года назад

@@Innozant Sir Hm website visit kiye bt Advance Excel and MIS ka fee itna h ki hm ek bar me paid nai kr payenge, kyu ki mai ek private job krta hu aur meri salary matra 15000 h.sir if any possibility for like me candidates them plz give me reply. Otherwise mai aapki sari video dekh k sikhne ka kosis kr rha hu.. Thank you sir😔

@Innozant 2 года назад

@@nishikant2354 Aap Innozant Whatsapp/Call Supoort Number par baat kijiye,Counselor will help you out.

@horrorlovestories 3 года назад

Sir 7: 14 mein jab main 3rd time revenue drag karta hoon toh sum of revenue2 ka column add hi nahi hota side mein aur percentage of grand total tak hi aa raha hai Sir please help ye column show nahi kar rah ? How to proceed further i got stuck🤔

@Innozant 3 года назад

Are aisa kyu..overlap to nhi kar re pivot ko..sepraye sheet para data leje banake dekhiye pivot

@horrorlovestories 3 года назад

Sir phir bhi nahi ho raha woh revenue field sum revenue 3 pivot table mein nahi show kar rah but value field mein khali show kar rah hai

@horrorlovestories 3 года назад

Sir mera problem solve ho gaya maine new workbook pe raw data copy karke practice kiya 😃

@chandrashekharkumbhar4843 Год назад

Hi sir, If i want 20% of the parent row total.

@Innozant Год назад

Use calculated field

@jaaneman01430 3 года назад

Hi Sir could u pls make video on my request I want percentage in pivot table Excel for example a/b ka % c/d % e/f % and g/h ka. % kaise karege pls sir reply

@Innozant 3 года назад

aap apna query detail me explain kijiye..Will make the video for the same