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…