Add a total field in PivotTable view

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

1. Open a datasheet or form in PivotTable view.

2. Click the field that contains the values you want to summarize.

3. On the PivotTable toolbar, click AutoCalc , and then click the summary function you want.