Pivot table calculated field:
This video shows how to add calculated field in pivot table, and is the next in our Pivot Table series. This beginners' tutorial provides an overview of how to add a calculated field to your Pivot Table (how to add calculated rows and columns). Want your Pivot Table to do some automatic calculations on your base data? This easy beginners tutorial will show you how to get those calculations in pivot tables:

0:00 Introduction
0:24 Inserting a Pivot Table
0:38 Setting up your Pivot Table
1:14 Adding calculations into your Pivot Table
1:49 Calculated Item (adding a calculated row)
3:53 Calculated Field (adding a calculated column)
5:24 Other formulas in Calculated Fields (multiplication and division)
6:30 List Formulas

The file I have used is the same as for my Guide to Pivot Tables video ( youtube.com/watch?v=1Sw3vNktQHs) which available to download from my Google Drive if you want to follow along or use it for reference in your own time.
Download the file here: drive.google.com/file/d/1vK5hBzztHPkQ13_2xet86ed16ytoyOGh/view?usp=sharing

Learn Excel online for free: Our Excel for beginners tutorial will teach you all you need to know to take you from zero to Excel hero!

What Microsoft Excel tips and tricks do you want to learn? Let me know for future videos! I'll continue to develop tutorials covering Excel basics for beginners and will build up a catalogue of free Microsoft Excel course materials! :-)

You can find all our Pivot Table videos in the following playlist: youtube.com/playlist?list=PLJWCoDBpUWeMrc8KEkz7liCMKxSCfae0F

Or here are the links to individual videos; check them out!
Introduction to Pivot Tables: youtube.com/watch?v=0Uzqtw6pdRU
Issues with PIVOT TABLES - fixing common errors: youtube.com/watch?v=uEXyXS_Ew3s
Pivot Charts: youtube.com/watch?v=85HYtObOOPI
Pivot Tables and Slicers: youtube.com/watch?v=Dyr4ycr-eSI

• PIVOT TABLE calculations: Add calculated field (Part 1: add calculated rows or columns) ( Download)
• How to add a calculated field to a pivot table ( Download)
• Add New Fields in a PivotTable using Calculated Fields ( Download)
• Excel PivotTable Calculated Items + the EASY way to Distinguish them from Calc. Fields ( Download)
• Pivot Table Calculations Basics: Calculated Fields, Items & Sets ( Download)
• How to add a calculated field to a Pivot Table in Excel ( Download)
• Add Calculated Fields with IF Statements to a Pivot Table ( Download)
• PIVOT TABLE calculations: Remove calculated field (Part 2: remove calculated rows or columns) ( Download)
• Excel Advanced - Calculated Items in a PivotTable - using percentages ( Download)
• How to Add Calculations for Variances in PivotTables ( Download)
• Advanced Pivot Table Techniques (to achieve more in Excel) ( Download)
• How to Add Calculated Fields to Your Pivot Table ( Download)
• Excel Pivot Table: How To Add a Percentage Column ( Download)
• Excel Pivot Calculated Item - No formulas needed in #Excel #pivottable #calculateditem ( Download)
• How to Add Calculated Fields in Excel Pivot Table ( Download)