Add or remove a field

Add a field

  1. In the design window, make sure the PivotTable list is activated. For instructions, see Help for your design program.
  2. Do one or more of the following:

    Add a field to the row, column, data, filter, or detail area

    1. On the toolbar in the PivotTable list, click Field List .
    2. Use the scroll bars and the Plus box and Minus box boxes to find the field you want to add to the PivotTable list.
    3. Click the field, and in the lower-right corner of the field list, select the area you want to add the field to.
    4. Click Add to.

    Notes

    Add a total field

    You can add total fields to the data area, but not to the row, column, detail, or filter area.

    1. Click the field that contains the values you want to summarize.
    2. On the toolbar, click AutoCalc , and then click the summary function you want.

    Note   The AutoCalc button is unavailable when the source data for the PivotTable list does not allow you to add total fields — for example, when the source data is from an OLAP database.

    Add a calculated total or detail field

    You can add a total or detail field that uses an expression to calculate data.

    1. On the toolbar, click Calculated Totals and Fields .

    2. On the menu that appears, do one of the following:

      • To create a total field, click Create Calculated Total.

      • To create a detail field, click Create Calculated Detail Field.

    3. In the Calculation tab of the Commands and Options dialog box, type the expression you want, and then click Change

      Tip

      To add field references, select a field that you want to use from the Insert Reference to box, and then click the Insert Reference To button.

    Note   To edit the expression that is being used in a calculated field, select the field, edit the expression, and click Change on the Calculation tab in the Commands and Options dialog box. The field values will be automatically recalculated using the new expression. 

Notes

Remove a field

When you remove a field from the layout of a PivotTable list, data from the field is no longer displayed; but the field remains available in the field list for viewing.

  1. In the design window, make sure the PivotTable list is activated. For instructions, see Help for your design program.
  2. Click the field label of the field that you want to remove from the PivotTable list.
  3. Drag the field outside the PivotTable list, until the pointer changes to Pointer with red X.

Notes