How to Add a Calculated Field to a Pivot Table in Excel - Profit Margin PivotTable Formula Example

Watch how to add a calculated field to your Pivot Table in Excel when that field does not exist in your original data set. Create a new field that performs calculations based on existing fields in your Pivot Table. In this video, we will create a new calculated field for Profit Margin by creating a formula that takes our Total Sales field, subtracts Total Cost of Goods Sold, and then divides by Total Sales to return our Profit Margin. Profit Margin is then an added field available to include in our Pivot Table data analysis.
TIMESTAMPS ⏰
00:00 Add Calculated Field to Pivot Table
00:18 Create a Pivot Table
01:05 Insert Calculated Field
WATCH NEXT 📺 Pivot Tables Made Easy: • How to Create Pivot Ta...
COURSE 🎒
Create Fillable Forms, Surveys & Questionnaires in Microsoft Word like a Pro: • Creating Fillable Form...
CHANNEL LINK 📺
/ @sharonsmith
Visit my Channel page on UA-cam to see all my videos, playlists, community posts and more!
TEMPLATES 📄
Check out my helpful list of templates available for purchase: creatoriq.cc/43c51cv
Thank you for supporting my channel! 🌟
FREE DOWNLOADS ⬇️
✦ Visit mailchi.mp/6a0859ea0844/sharo... to sign-up for my e-mail list and get FREE downloads of super helpful spreadsheet formulas, dashboards and Org Chart templates for HR professionals.
CONNECT WITH ME 📎
Visit my website: www.sharonsmithhr.com for more information, tools and resources.
LinkedIn: / sharonsmithhr
Twitter: / sharonsmithhr
Instagram: / sharonsmithlearning
Facebook: / sharonsmithlearning
GEAR ⚙️
🎙 Blue Yeti USB Microphone: amzn.to/2W4SbzV (Great for recording professional sounding audio for your videos!)
🖱 Silent Mouse: amzn.to/3pxpc25 (This is a really cool mouse!)
🎥 Screen Recording Software: techsmith.z6rjha.net/NZG5b
📗 Green Screen: amzn.to/2DnHsY2
📸 Camera: amzn.to/39KvpQA
🔌 Live Stream Tool: amzn.to/2VFJyID (Turns your DSLR into a top notch webcam)
RESOURCES 📚
✏️ JotForm: www.jotform.com/pricing/?utm_...
🖥️ TechSmith Camtasia Screen Recording: techsmith.z6rjha.net/SharonSm...
📑 Wondershare PDFelement (PDF Editor): bit.ly/31QEkA8
💻 PresenterMedia: shareasale.com/r.cfm?b=417324...
Links included here are affiliate links. If you click on these links and make a purchase, I may earn a small commission at no additional cost to you. Thanks for supporting this channel!
SUPPORT THIS CHANNEL 🙌
- Hit the "$Thanks" button on any video, or
- Donate through my PayPal link: www.paypal.com/cgi-bin/webscr...
If you found this content helpful, please consider donating to my channel. Your donation, no matter what amount, is greatly appreciated and goes towards producing more content that enhances your productivity and elevates your skills.
You can also support my channel just by watching, liking, and sharing all my videos! Thank you so much! ❤️
PLAYLISTS 🎥
➤ Jotform Tutorials: • Jotform Tutorials
➤Create A Letterhead in Word: • Create A Letterhead in...
➤Creating Fillable Forms: • How To Create A Fillab...
➤PowerPoint Tutorials: • PowerPoint Tutorials
➤ Excel Tutorials: • Microsoft Excel Tutorials
➤ Excel Tips & Tricks: • Excel Tips & Tricks
➤ Word Tutorials: • Microsoft Word Tutorials
KEYWORDS: @SharonSmith

[@syedqaisarabbas5904]

Hello sharron how are you good evening u know I was waiting for your video very impatiently thanks for your love and respect love u my incredible teacher.

[@SharonSmith]

Glad to help! Thanks for watching!

[@syedqaisarabbas5904]

U hv incredible voice.

[@SharonSmith]

Thank you for watching my videos!

[@rifteeridmee]

Sometimes Calculated Filed is inactive, why it occurs, and how active it is, please.

[@JamieMurphy-ic2yd]

she's cute xx

[@SharonSmith]

Thanks for watching!