Pivot Table Show Value as : % Parent Total, % Parent Row Total, Difference From,Running Total, Rank
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
Пікірлер: 150
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 👍
I have seen many videos on pivot table but Your teaching style is very good. Thanks for sir.
You teach very well sir. Thank you for your valuable time that you are giving to us through KZread. keep teach to us 🙏
Excellent video on this topic. Thanks a lot
Your presentations are extraordinary,, congratulations and thanks
@Innozant
2 жыл бұрын
Thanks dear..God bless you.❤️
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 ❤️
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.😊🙏
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
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🙏♥️
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.
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!
Ur explanation is superb, ur smiling face is very nice 👍
@Innozant
3 жыл бұрын
Thanks Sandeep ji for your valuable appreciation ❤️🙏
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...😊🙏
Complicated but beautiful and when explained by Dilip sir, it is more beautiful.
@Innozant
6 ай бұрын
Thanks
Sir ye Sab Sikhane k Bhoot Sare KZread 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
Nicely explained 😌
Excellent 👍👍
sir ap ka video best h hum sabhi ke liye
Again, Salute to you
Thankuu sir I am so grateful I found your channel this is very useful
@Innozant
2 жыл бұрын
❤️👍
Excellent
bahot he maza ah aya sch main sir thank you sir aaap ka bahot bahot ehsan hai
@Innozant
3 жыл бұрын
Thanks Sawai..
very useful sir
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
Sir good job 👍👍👍
Thankx
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
Superb Sir very very helpful
@Innozant
3 жыл бұрын
Thanks Dipesh Ji.
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.
Extraordinary
Wow amazing thanks sir
@Innozant
3 жыл бұрын
Thanks Bhoopendra for wonderful feedback..tc..gn
Well done💯👍
@Innozant
2 жыл бұрын
Thanks Kuldeep Ji
Thanks Sir
thanks sir
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
Awsome 🖤💐💐
@Innozant
3 жыл бұрын
Thanks Lokesh ji
Very good
love you guy
@Innozant
Жыл бұрын
Thanks dear
Can we use this tools to analyse Economics Marginal cost and total cost concept ? By the way .....you r god to us
Amazing sir
@Innozant
3 жыл бұрын
Thanks Umair Sahab❤🙏
u r gr8 sir
@Innozant
3 жыл бұрын
Thanks Pavan ..hv a nice day
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
Brilliant
@Innozant
3 жыл бұрын
Thanks dear🙏❤️
So nice Sir ji 😄
@Innozant
3 жыл бұрын
Thanks dear Saboj ji❤️🙏
Thnq sir
@Innozant
3 жыл бұрын
❤️♥️👍🙏
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 :)
nice
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.
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 .
Good vidio hai sir ji
@Innozant
2 жыл бұрын
Thanks dear
🙏🙏
Bahot badhiya sir ❤️ Sir power bi bhi advance sikhayege ? Excel ke jaisa 😊
@Innozant
Жыл бұрын
Yes dear
@Altaf_Alam
Жыл бұрын
@@Innozant love u my dear sir ❤️😀
⭐⭐⭐⭐⭐
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)
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.
Brokerage+ reward/70%. (If ke formule me Sum ka aur umesme persentage nikala sakte hai kya)
Thank you very much for this wonderful video 🙏, Sir MS OFFICE 2019 कैसे download kare please Help Me 🙏
How use var, char etc in "value of" in pivot table.
Sir please power pivort ke video laye
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
Sir if I am filter the pivot the % are change please explain how we can stop this
Sir how to show the growth of% in pivot table.
Sir vba code with excle table with filter /slicer and send selected table to email??
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 ......
Sir how can see financial year wise
@Innozant
3 жыл бұрын
In pivot or using funcation you want
Sir muje ye PTA krna h ki 25year to 45 year ke under kitne candidate h
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
sir why and where we use data model check.
@Innozant
2 жыл бұрын
Data model is use to establish the relationship between multiple tables
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.
Hello sir kya haal hai 🙏
@Innozant
3 жыл бұрын
Theek hain..ap bataiye .Kahan gayab the ..?
@rjraviraftarup7553
3 жыл бұрын
@@Innozant actually sir Pradhan Ji logon ki training chal rahi hai panchayati Raj vibhag me tu usi mein thoda vyast Hai
how to get this date please provide data
Sir excel 2007 me data model ka optn kaha hai?
Hi sir, If i want 20% of the parent row total.
@Innozant
Жыл бұрын
Use calculated field
Where's the link for the previous video?
@Innozant
2 жыл бұрын
Kindly watch the assignment link in video description -assigment master 2nd link
distinct count not available Excel-2010
Sir ye disting count Excel 7 me kaise kare... Please sir guide
@Innozant
3 жыл бұрын
Right click on any cells of count of columns..then value field settings-distinct count
@pramodcomputertips7872
3 жыл бұрын
@@Innozant thanks sir
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
2 жыл бұрын
Are aisa kyu..overlap to nhi kar re pivot ko..sepraye sheet para data leje banake dekhiye pivot
@horrorlovestories
2 жыл бұрын
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
2 жыл бұрын
Sir mera problem solve ho gaya maine new workbook pe raw data copy karke practice kiya 😃
Distancet count kya hota h ye kisleye use hota h
@Innozant
3 жыл бұрын
Unique count ..data set me se unique count Krna ho to.
@virendersroha1754
3 жыл бұрын
@@Innozant ok sr
Sir mere pas excel 2007 hai...i couldnt find parent total option...plz guide me..
@Innozant
3 жыл бұрын
plug in ki jrurat hogi..latest version kar lijiye install
@rajukumar-uh7pr
3 жыл бұрын
@@Innozant ok sir
Value me 3 coloum se jyada nehi aa raha hai sir. Apka kaise aa raha hai sir
Sorry see you late
@Innozant
3 жыл бұрын
Thanks ..dear
Value ke जगह text चाहिए तो कैसे करें।
@Innozant
2 жыл бұрын
The bhi koi issue nhi h
Excellent 👍👍
@Innozant
3 жыл бұрын
😊🙏
Thanks sir