Microsoft Office Tutorials and References
In Depth Information
In this exercise, you’ll rename a PivotTable, specify whether subtotal and grand total rows
will appear, change the PivotTable summary function, display each cell’s contribution to its
row’s total, and create a formula that incorporates a value in a PivotTable cell.
SET UP You need the Editing workbook located in the Chapter10 practice file folder
to complete this exercise. Open the workbook, and then follow the steps.
On the PivotTable worksheet, click any cell in the PivotTable.
On the Analyze tool tab, click the PivotTable button and then, in the PivotTable
Name field, enter VolumeSummary and press Enter to rename the PivotTable.
On the Design tool tab, in the Layout group, click Subtotals , and then click Do Not
Show Subtotals . Excel removes the subtotal rows from the PivotTable.
On the Design tool tab, in the Layout group, click Grand Totals , and then click On
for columns only . Excel removes the cells that calculate each row’s grand total.