Microsoft Office Tutorials and References
In Depth Information
Changing the Format of a PivotTable
Figure 12-14 Use the Grouping dialog box to collapse and subtotal large amounts of
timebased data into slices—by year and by quarter, in this example.
If you look carefully at Figure 12-14, you’ll notice that Excel worked its magic by creating
a new calculated field called Years (it’s at the bottom of the field list, with a filter icon to its
right). The Ungroup menu lets you clear the current grouping arrangement and start over.
Changing the Format of a PivotTable
The Design tab contains a full range of options for customizing the look and feel of a
PivotTable report. It’s visible at the right side of the ribbon, under the PivotTable Tools heading,
whenever the active cell is in a PivotTable.
The options in the Layout group allow you to quickly show or hide subtotals and grand
totals. You can show subtotals at the top or bottom of a group and calculate grand totals
for rows or columns or both.
Search JabSto ::

Custom Search