Excel Pivot Table Calculated Items and Calculated Fields

Get the sample workbook from the Pivot Table Calculated Items and Calculated Fields page on my website:
https://www.contextures.com/calculatedfieldcalculateditem.html

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 List Formulas
5:02 Get the Sample File

Instructor: Debra Dalgleish, Contextures Inc.
Get Debra's weekly Excel tips: http://www.contextures.com/signup01
More Excel Tips and Tutorials: http://www.contextures.com/tiptech.html
Subscribe to Contextures YouTube: https://www.youtube.com/user/contextures?sub_confirmation=1

Видео Excel Pivot Table Calculated Items and Calculated Fields канала Contextures Inc.