Microsoft Office Tutorials and References
In Depth Information
Compute PivotTable
SUB AND GRAND TOTALS
You can use PivotTables to compare and contrast the
distribution of data across categories. You may need
a variety of statistics to examine differences between
categories. To aid you, PivotTables can automatically
calculate subtotals and grand totals for the columns
and rows in your list. When calculating subtotals and
grand totals, you have a choice of calculations from
which to choose, including sum, average, count,
standard deviation, minimum, and maximum.
To change the summary statistic, open the Value
Field Settings dialog box and choose the type of
calculation you want to use to summarize your data.
Changing the type of calculation used to generate
values in a row or column can result in improperly
formatted data. To remedy this, use the Number
Forward button in the PivotTable Field dialog box to
access the number-formatting capabilities of the
Format Cells dialog box. You may, for example, want
to add a thousands separator so you see 7,236,273
instead of 7236273.
2
1
Click any field in your
PivotTable.
3
The PivotTable tools become
available.
l
2
Click the Options tab.
1
3
Click Field List.
The PivotTable Field List
becomes available.
4
Click the field for which you
want a subtotal or grand total.
A menu of options appears.
5
4
5
Click Value Field Settings.
l The Value Field Settings dialog
box appears.
6
Click the type of calculation
you want to use to summarize
your data.
This example uses MAX .
7
Click Number Format.
6
7
116
 
Search JabSto ::




Custom Search