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 ❤️

[@litonkumer326]

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

[@Innozant]

Thanks dear..Happy Learning ❤️

[@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]

👍❤️

[@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

[@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❤️❤️👍

[@jadeedjadeed3150]

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

[@Innozant]

Thanks dear...Happy learning ❤️

[@krishnaaryan2903]

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

[@ankurghosh7734]

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

[@Innozant]

Thanks Ankur Ji .Keep learning

[@shibapaningrahi8749]

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

[@Innozant]

Thanks Shiba

[@rashidabbasi679]

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

[@Innozant]

Thanks Rashid 👍

[@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 ❤️

[@zuebansari6799]

I have enjoyed every second of the video, Simplicity

[@Innozant]

Thanks

[@ashishshiriskar123]

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

[@Innozant]

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

[@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

[@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 ♥️

[@aman1470]

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

[@rinturoy8014]

Wonderful video, I got insight into calculated field deeply

[@anbiakhan8306]

Most beautiful way of teaching .... Wow

[@Innozant]

Thanks Khan sahab..Never stop learning

[@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

[@supranab]

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

[@Innozant]

Thanks

[@TechTalksWithAamir]

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

[@Innozant]

Thanks Aamir😊❤️

[@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

[@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.🙏♥️🙂

[@ab_Chitrkatha]

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

[@Innozant]

Thanks Abhi❤️❤️

[@vishalgali7761]

Bilkul badhiya explanation diya sir. thank you

[@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

[@payelbhattacharya3795]

Amazing and clear explanation. Thank you so much sir.

[@Innozant]

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

[@nadimsheikh]

your presentation is so alive

[@Excelhero1122]

Special love 😘 from Pakistan. I have subscribed your channel

[@Innozant]

Thanks ..Keep learning

[@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.🙏♥️🙂

[@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

[@gautamgidwani5553]

Thank you for making it so simple.

[@Innozant]

Thanks Gautam Ji

[@gollusingh007]

Very nice and informative concept.

[@madhavtewary2421]

Extremely helpful video sir

[@pramodchandelpkc]

VERY PRODUCTIVE . THANKS FOR SHARING

[@sudiptamanna4195]

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

[@tinny2761]

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

[@Innozant]

Thanks Tamannna..keep learning ❤️

[@niraj9896]

Sir aap bahut badiya sikhaate ho..

[@DineshSingh-lc5gk]

gr8. you are my excel teacher.

[@sukhbirvirdi5867]

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

[@Innozant]

Thanks Sukhbir

[@GaganDeep-mj5hi]

Very knowledgeable video. 🙏🙏

[@rewatiraman2956]

Bahut is accha samjaya hai ,apko koti koti dhanyabad

[@Innozant]

Thanks dear♥️👍

[@asmrindia]

Thanks a Lot Sirji

[@Urf_Keshav]

Thanks for this knowledge sir you are Great❣️

[@Innozant]

Thanks Vardha ..

[@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

[@pbxkaaliii]

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

[@shabanashaik5724]

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

[@Innozant]

Good Morning.. Thanks Shabana🙏❤️

[@msexcelgooglesheet374]

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

[@Innozant]

Thnks dear..🙏♥️🙂

[@FAISALSHAHZAD-je9sd]

Excellent Brother 👍👍

[@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 ❤️🙏

[@horrorlovestories]

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

[@pankubisht3495]

You are master of excel sirji

[@Innozant]

Thanks Panku❤🙏

[@kartik123007]

Excellent insights... Thanks a Lot...

[@Innozant]

Thanks Kartik..Happy Learning ❤️

[@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🙏🙏🙏❤❤❤

[@poojakajla6516]

Sabse badiya sikhate h aap excel

[@Innozant]

Thanks Pooja..God bless You.

[@ankitkanojia8330]

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

[@Innozant]

Thanks Ankit Ji.Keep learning ❤️👍

[@reetakisna]

Dear sir very nice series

[@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🙏🙂

[@ganerpatai8182]

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

[@sushilaswal8950]

Very useful topic sir

[@gaurishankar2358]

Nice explanation sir thank you

[@asthagoel6177]

Thank you so much for this vedio❤

[@Sachin19831000]

Thank u so much for valuable information 🙏🏻

[@Innozant]

Thanks Sachin Ji ❤️❤️

[@sachinjagalekar7288]

Thanks a lot for your help

[@MahmudulHasan-ox1fo]

Boss thanks for your tips

[@forgotten_friend5406]

nice teaching methods sir

[@maddy2613]

Thank you sir.

[@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. ....

[@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

[@ptejwani]

Thanks God bless you

[@Innozant]

Thanks Pratap Ji .Happy Learning ❤️

[@sujankrishna5863]

Really great effort bro 👍

[@Innozant]

Thanks Sujan

[@Radhe.mahant2010]

Best video for piv tab

[@Innozant]

Thanks Dear❤️

[@manishanegi9132]

Please advise if the pivot table that has pivot fields and items could be used in the dashboard? I am trying to connect that this pivot table (with calculated field and items) with other tables (with the same data source) in the dashboard , but it is not getting conneted.

[@Innozant]

Hi Manisha Kindly share your data sheet format with detail explanation on @innozantofficial telegram id

[@manishanegi9132]

@@Innozant I could correct the error later. Thank you for your prompt reply. Your videos are extremely explanatory. There is hardly a problem that remains unsolved.

[@gauravbanerjee7891]

Sir last wala trick awesome tha.

[@Innozant]

Thanks dear ❤️

[@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?

[@Ann_2208]

Amazing skill 👍

[@Innozant]

Thanks dear❤️❤️

[@gamehub8068]

Thank you sir 🙏🙏🙏

[@Innozant]

Thanks

[@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

[@atulgoodify]

Great work

[@subratasardar4058]

Amazing video sir

[@Innozant]

Thanks Subrata❤️❤️

[@Editor332-zp6kd]

thank you so much your effeorts

[@Tanuj-tricker]

Dear Your excellent

[@Innozant]

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

[@kapilkashyap7026]

Well done sir

[@kinghundred]

very useful sir

[@ramkrishnasingh2049]

Thanks for this info. But how we come to know that we have created calculated fields? Any idea how to identify

[@Innozant]

Offcourse you can see the calculated field in excel ,Just see the list in tab

[@rahulrakshe1988]

I learned new thing today

[@v.m.lokeshbabu9627]

thank you for support

[@Innozant]

Thanks dear

[@kaularam7263]

Very nice 👍 sir

[@Innozant]

Thanks Dear..Happy Learning

[@sudiptakar9157]

best teacher

[@Innozant]

Thanks Sudipta

[@simpalranjan5161]

Can we add a Calculated row in the power pivot table?

[@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.

[@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..🙏🙂

[@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.

[@jignesh2233]

sirji its nice but i am making pivot table from two different data table so can not see calulated field in analyze (field, item and sets) so what i can do ?

[@Innozant]

Create relationship between tables first

[@shiashots110]

Thank you Sir

[@neharathore7393]

Thanks a lot sir ji

[@vikramkumar-ch2gw]

Sir if we want to add count of no as per condition then what should be do