Creating a calculated field


show more Creating a calculated field provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2010: Pivot Tables in Depth show less
please wait ...

Creating a calculated field

PivotTables enable you to analyze your data efficiently, but some questions can only be answered by performing calculations on the data used to create your PivotTable. To perform that type of analysis you can create custom fields that summarize PivotTable data using a formula. Without calculated fields, you'd have to copy the data from your PivotTable, paste it on another worksheet, and create the formulas there and that's a pain. Now you have to dig a little to find the button you click to create a calculated field, but you can find it by clicking the Options contextual tab on the Ribbon and then in the Calculations group click Fields, Items & Sets, and the item you want on this menu is Calculated Field.

When you click Calculated Field the Insert Calculated Field dialog box appears. Now you can type a name for your calculation and in this case I will call it Average Sale, and now I can create the formula. To create a formula I'll click in the Formula box and backspace to...

Creating a calculated field
Video duration: 2m 27s 3h 43m Intermediate

Viewers:

Creating a calculated field provides you with in-depth training on Business. Taught by Curt Frye as part of the Excel 2010: Pivot Tables in Depth

Subject:
Business
Software:
Excel
Author:
please wait ...