Excel Pivot Table Calculated Items and Calculated Fields




About this tutorial:

Video duration: 00:05:15
Get the sample workbook from the Pivot Table Calculated Items and Calculated Fields page on my website:

You can add two types of custom formulas to an Excel pivot table – Calculated Items and Calculated Fields

Watch this video to see the difference between Pivot Table Calculated Items and Calculated Fields.

Also, see an example of how to add each type of formula, then create a list of the formulas in the pivot table.

Video Timeline:

0:00 Intro
0:30 Pivot Table Formulas
1:04 Calculated Item
2:50 Calculated Field
4:06…

Post Author: OfficeTutes.com

Apple lover, ICT and LEAN consultant, MS Office lecturer My other website with video tutorials - Tutorials, guides and news for iPhones and iPads