Microsoft Office Tutorials and References
In Depth Information
Grouping Pivot Table Items
Viewing grouped data
Excel provides a number of options for displaying a pivot table, and you may want to experiment
with these options when you use groups. These commands are in the PivotTable Tools
tab of the Ribbon. There are no rules for these options. The key is to try a few and see which
makes your pivot table look the best. In addition, try various PivotTable Styles, with options for
banded rows or banded columns. Often, the style that you choose can greatly enhance readability.
Figure 18-22 shows pivot tables using various options for displaying subtotals, grand totals, and
Figure 18-22: Pivot tables with options for subtotals and grand totals.