Part IV: Managing and Analyzing Data
FIGURE 30.15
The Insert Calculated Field dialog boxFigure 30.16 shows the PivotTable after adding the calculated field. The new field displayed
Sum of Average Unit Price, but the label was shortened to Avg Price.FIGURE 30.16
This PivotTable uses a calculated field.