Excel Pivot Table Calculated Fields and Calculated Items | How to add a calculated field to a pivot

[@abhi_bharat]

beauty lies in simplicity. this is my first ever comment in youtube. and the reason being, the video is worth it. im sure whoever watches the content will be amazed by the simplicity of the instructor. enjoyed every second of the video.

[@Innozant]

Thanks Abhirash.Really means a lot to me..God bless You..Have a wonderful career ahead ❤️

[@sewakramrahi3813]

एक नया विषय नये तरीके से समझने के लिये समझाने वाला गुरू मिल गये। धन्यवाद महोदय ।

[@Innozant]

Thanks Sewak Ram ji..have a wonderful career ahead

[@VlogShack16-kl4zo]

One of the best online tutor available on youtube.

[@Innozant]

Thanks.Keep learning

[@karimsamnani3660]

I'm from Pakistan, Thank you very much, for the beautiful explanation of the excel pivot table calculated Fields & Items.

[@Innozant]

👍❤️

[@litonkumer326]

I am from Bangladesh. I am learning a lot from your tutorials. Thank you sir .

[@Innozant]

Thanks dear..Happy Learning ❤️

[@SylvesterMarshallPune]

Teaching is really an Art and you've proved it. As i get addicted watching your videos, i feel so confident after grasping your trainings. Your teaching is so awesome that you need not request viewers to subscribe your channel as anybody will feel compelled to subscribe on their own. God bless you for sharing your knowledge and for the good work you're doing.

[@Innozant]

Thanks dear.Keep Learning..Keep Exploring 👍❤️

[@Azhar_Khan383]

I've been using Pivot Table for many years but don't know such types of options are available, but today because of you I lean a lot of new things. I don't have a word to praise you. Thank You, sir, for the wonderful knowledge sharing with us.

[@Innozant]

Thanks Azhar sahab.Happy learning.. God bless you❤️❤️

[@rajinderdhammi3819]

Jis prakar

[@krishnaaryan2903]

This is awesome.....teaching excel with so simplicity

[@jadeedjadeed3150]

Sir thank you.. I made my boss impressed by your excel tricks..he also love to use excel

[@Innozant]

Thanks dear...Happy learning ❤️

[@ankurghosh7734]

VERY GOOD PIVOT SERIES TUTORIALS AND YOU ARE SUPERMAN IN EXCEL ,THANKS

[@Innozant]

Thanks Ankur Ji .Keep learning

[@vishalgali7761]

Bilkul badhiya explanation diya sir. thank you

[@bhagatrishi5454]

oh my god each video is taking me to in depth analysis approach to share market data as well with ease.

[@Innozant]

Thanks mm❤️❤️👍

[@rashidabbasi679]

thanks sir understanding classes easy way for teaching ,,simple language . thanks of lots sir

[@Innozant]

Thanks Rashid 👍

[@zuebansari6799]

I have enjoyed every second of the video, Simplicity

[@Innozant]

Thanks

[@msexcelgooglesheet374]

Awesome Video sir ji maza aa gaya..................

[@Innozant]

Thnks dear..🙏♥️🙂

[@brijnarayan1234]

samjhane ka tarika bohot accha hai ap ka

[@Innozant]

Thanks Brij Narayan ..Aapko samjh aata hai aur aap in videos se seekh rhe hain wo jyada Khushi deta hai mujhe

[@rohinikrishna3601]

Learning from each of your video, classes can be this interesting.... never I know; you are making me wise, 😇, thank you.

[@Innozant]

Thanks dear Rohini...Have a wonderful career ahead ❤️

[@rinturoy8014]

Wonderful video, I got insight into calculated field deeply

[@ashishshiriskar123]

You are a very good teacher. 👍👍👍👍👍 God bless you 🙏🙏🙏🙏

[@Innozant]

Thanks Ashish ji for your valuable appreciation..Happy learning ❤️

[@anbiakhan8306]

Most beautiful way of teaching .... Wow

[@Innozant]

Thanks Khan sahab..Never stop learning

[@aman1470]

Wonderful teaching❤ It will certainly improve my skill in excel work

[@shibapaningrahi8749]

Thank you sir for explaining every topic clearly in detail , the way you teach is very interesting!

[@Innozant]

Thanks Shiba

[@niraj9896]

Sir aap bahut badiya sikhaate ho..

[@rewatiraman2956]

Bahut is accha samjaya hai ,apko koti koti dhanyabad

[@Innozant]

Thanks dear♥️👍

[@TechTalksWithAamir]

Excellent and very easy way of presentation. Keep up the good work.

[@Innozant]

Thanks Aamir😊❤️

[@puransingh-sx2tk]

Naa kabhi dekha na suna waha guru g maja aa gaya 👌 😊

[@Innozant]

Thanks Puran Ji,Aise hi andekha anajana. Safar chalata rhega humesha ..Keep watching and learn unique concept.🙏♥️🙂

[@Excelhero1122]

Special love 😘 from Pakistan. I have subscribed your channel

[@Innozant]

Thanks ..Keep learning

[@anshulsharma9131]

Thank you so much, brother 🙏 Extremely helpful session. So nicely explained, and it took me just few minutes to understand and apply. I've just subscribed to your channel. 😊👍🤘

[@Innozant]

Keep learning..keep exploring

[@ArvindKumar-tu2ky]

This video was very important for me, I was searching this video many days. Thanks you

[@Innozant]

Thanks Arvind..Happy Learning dear.God bless you

[@AbdulBasit-ex9pw]

Honourable sir , Believe me a lot of excels tutorials are available on youtube but but but your teaching level is incredible , i have no words to appreciate your efforts & your knowledge. Love & Respect from Pakistan 🇵🇰

[@Innozant]

Thanks Abdul..Reall means a lot , Love you dear ..Happy Learning 😊

[@AbdulBasit-ex9pw]

@@Innozant Thanks sir for your kind response ♥️

[@nadimsheikh]

your presentation is so alive

[@poojakajla6516]

Sabse badiya sikhate h aap excel

[@Innozant]

Thanks Pooja..God bless You.

[@gollusingh007]

Very nice and informative concept.

[@payelbhattacharya3795]

Amazing and clear explanation. Thank you so much sir.

[@Innozant]

Thanks Payal for your valuable appreciation..God bless you..Keep learning..keep exploring ❤️

[@ab_Chitrkatha]

You are the best excel teacher dear god bless you. ।

[@Innozant]

Thanks Abhi❤️❤️

[@shashankku.1469]

I wish could have teacher like you at the beginning of my career..your teaching skills is very good sir

[@Innozant]

❤️❤️ Thanks dear

[@satishojha6240]

Good morning sir thanks new concept of pivot table and wai ting power pivot table.have a nice day sir

[@Innozant]

Thanks Satish ji.🙏♥️🙂

[@rakeshkumarbarman5232]

I keep watching ur all videos and I just want to say one thing that 'Aap khatarnak ho sir'🙏🙏🙏

[@Innozant]

Hahahaha... Thanks Rakesh Ji

[@GaganDeep-mj5hi]

Very knowledgeable video. 🙏🙏

[@supranab]

Excellent way of explaining the things. Need to get course for conditional formatting

[@Innozant]

Thanks

[@madhavtewary2421]

Extremely helpful video sir

[@sudiptamanna4195]

Wow You are great ...Thanks Sir It is now working office 2010 version

[@DineshSingh-lc5gk]

gr8. you are my excel teacher.

[@pramodchandelpkc]

VERY PRODUCTIVE . THANKS FOR SHARING

[@FAISALSHAHZAD-je9sd]

Excellent Brother 👍👍

[@asmrindia]

Thanks a Lot Sirji

[@gautamgidwani5553]

Thank you for making it so simple.

[@Innozant]

Thanks Gautam Ji

[@Urf_Keshav]

Thanks for this knowledge sir you are Great❣️

[@Innozant]

Thanks Vardha ..

[@ankitkanojia8330]

Thank you very much sir, bohot shi tareeke se samjhaya aapne.

[@Innozant]

Thanks Ankit Ji.Keep learning ❤️👍

[@tinny2761]

Oh my god!!! Such an amazing video!! Learnt a lot from youuuu. 😀Keep making new videos.

[@Innozant]

Thanks Tamannna..keep learning ❤️

[@shabanashaik5724]

Really super sir....great explained..hats off

[@Innozant]

Good Morning.. Thanks Shabana🙏❤️

[@pankubisht3495]

You are master of excel sirji

[@Innozant]

Thanks Panku❤🙏

[@sameenarafiq1339]

Very informative nicely delivered lecture... Thanks again Sir

[@Innozant]

Thanks Sameena ..We welcome you to experience the taste of Success with Innozant Seed of Success ❤️🙏

[@reetakisna]

Dear sir very nice series

[@kartik123007]

Excellent insights... Thanks a Lot...

[@Innozant]

Thanks Kartik..Happy Learning ❤️

[@ganerpatai8182]

Very nice and magical 👍👍👍👍👍👍👍👍

[@devendergusain8974]

sir meri 4 ID hai gmail pe sari id se susbcribe kar chuka hu keep going... thnx u sir

[@Innozant]

Thanks Dev,Really means a lot to me..Love you all🙏🙏🙏❤❤❤

[@pbxkaaliii]

Thank you so much i was looking this from a long time. Thanks alot

[@sukhbirvirdi5867]

Awsome Sir, u make such advance learning also fun ,hats off 2 u🙏

[@Innozant]

Thanks Sukhbir

[@gaurishankar2358]

Nice explanation sir thank you

[@asthagoel6177]

Thank you so much for this vedio❤

[@sushilaswal8950]

Very useful topic sir

[@horrorlovestories]

Sir thank you so much this percentage trick is very time saving i made a note of it and practiced too 😀

[@forgotten_friend5406]

nice teaching methods sir

[@gauravbanerjee7891]

Sir last wala trick awesome tha.

[@Innozant]

Thanks dear ❤️

[@pramodbhavsar4488]

Very nice tutorial about pivot column & raw with analysis tab thank you sir

[@Innozant]

Thanks Pramod..Will ulload complete tutorial of Pivot Table step by step🙏🙂

[@MahmudulHasan-ox1fo]

Boss thanks for your tips

[@sachinjagalekar7288]

Thanks a lot for your help

[@rajukdavis]

Excellent tricks which is very useful and not easily seen in other tutors. All your teachings are well appreciated and thank you very much. I request a help. I am not able to catch up with your speaking speed. Suggest for slow expressions.

[@Innozant]

Thanks Raju for your valuable appreciation... Ok sure will work on speed .it's not a big issue

[@maddy2613]

Thank you sir.

[@Sachin19831000]

Thank u so much for valuable information 🙏🏻

[@Innozant]

Thanks Sachin Ji ❤️❤️

[@sawaimalhi8439]

percentage wali tpis tu aaaap ki kamal hai wa sir

[@Innozant]

Thanks dear

[@Radhe.mahant2010]

Best video for piv tab

[@Innozant]

Thanks Dear❤️

[@sujankrishna5863]

Really great effort bro 👍

[@Innozant]

Thanks Sujan

[@priyanktyagi5725]

13:52 mujhe top column mai sirf sabhi region ke total ko subtotal karna hai on top kya formula use karna padega Pls suggest. ....

[@ptejwani]

Thanks God bless you

[@Innozant]

Thanks Pratap Ji .Happy Learning ❤️

[@rahulrakshe1988]

I learned new thing today

[@gamehub8068]

Thank you sir 🙏🙏🙏

[@Innozant]

Thanks

[@subratasardar4058]

Amazing video sir

[@Innozant]

Thanks Subrata❤️❤️

[@Tanuj-tricker]

Dear Your excellent

[@Innozant]

Thanks Verma Ji..Really means a lot to me dear

[@kapilkashyap7026]

Well done sir

[@ketanshah3736]

Excellent. Thanks

[@ketanshah3736]

I tried using If Function in calculated field. There are 12 records. 6 with value D and 6 with value C in master table. I created If Function depending on value C or D. It is taking 10 rows for calculation instead of 6. Strange. I can understand if it takes all or none. But 10 out of 12 having different values giving same answer is something I don't understand

[@kaularam7263]

Very nice 👍 sir

[@Innozant]

Thanks Dear..Happy Learning

[@kinghundred]

very useful sir

[@Editor332-zp6kd]

thank you so much your effeorts

[@Ann_2208]

Amazing skill 👍

[@Innozant]

Thanks dear❤️❤️

[@atulgoodify]

Great work

[@davidsonsunny2886]

Zabardast Bhai

[@sudiptakar9157]

best teacher

[@Innozant]

Thanks Sudipta

[@neharathore7393]

Thanks a lot sir ji

[@shrikantpatel9434]

Hi Sir very useful video, one question like I want to subtract the amount from month of Dec to Jan. In that case where I have put mouse crosser in the Pivot table? I want use the Calculated fields option

[@AnupKumar-oe2jb]

Wao great sir, thank you so much..

[@Innozant]

Thanks Anoop.Happy Learning..🙏🙂

[@hsgusain2054]

Gjb ....🙏🙏🙏

[@Innozant]

Thanks Gusaij sahab🙏❤️

[@KishanKumar-os8dc]

Sir I have a doubt: At 10:16 seconds the Grand Total of % of Rebate should be the total of the same column but it looks like it is taking the 10% of sum of Sale and showing that as the total of % of Rebate. It should have been $622 but the total there is $1,412 do you know how to fix this?

[@v.m.lokeshbabu9627]

thank you for support

[@Innozant]

Thanks dear

[@shiashots110]

Thank you Sir

[@bishtlokesh1297]

Please you do finished the all pivort table videos in upcoming videos it's must and very good morning have a nice day sir ji

[@Innozant]

Sure Lokesh..,Keep watching..Complete tutorial soon uploaded for Pivot Table.

[@brijnarayan1234]

very nice sir

[@Innozant]

Thanks Brij Narayan Ji...tc..Gn...❤️👍🙏🙏

[@BouncewithLife_1]

Thanks for this video Innozant. One ask please, Instead of calculated field if I simply want to add a field for commentary so that I can ask for comment from my stakeholders. If I simply write this on column next to pivot table so in case anytime when filter pivot, it does not include this manual added comment column as result not able to see corresponding comments.

[@kediasc]

Very good

[@sonugupta6831]

sir, if i have created pivot table on the basis of multiple sheets with power query, then calculation field is not enable for me in that scenario what to do? pls help