PIVOT TABLE calculations: Add calculated field (Part 1: add calculated rows or columns)

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 (   • Beginners guide to Pivot Tables: lear...  ) 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: https://drive.google.com/file/d/1vK5h...

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:    • Плейлист  

Or here are the links to individual videos; check them out!
Introduction to Pivot Tables:    • Learn Pivot Tables in 7 Minutes | Int...  
Issues with PIVOT TABLES - fixing common errors:    • Issues with PIVOT TABLES - fixing com...  
Pivot Charts:    • Introduction to PIVOT CHARTS. Learn t...  
Pivot Tables and Slicers:    • Excel Pivot Table Slicers: Learn how ...