Page 147 - Excel Data Analysis

08 537547 Ch07.qxd 3/4/03 12:07 PM Page 133

WORKING WITH PIVOTTABLE REPORTS 7

If you have a series of dates in a field, you can You can remove any grouping from a PivotTable. To
use the Grouping dialog box to specify the way do so, select the group and click Data ➪ Group and
you want to group the items in the field. With Outline ➪ Ungroup. When you remove a group, it
this dialog box, you can have Excel create no longer exists as part of the PivotTable. If you
multiple groups with one step. For example, if want to view the group again you must re-create it.
you have dates from five different months, you
can group the dates by Months, and Excel creates If you just want to hide a group, you can click the
a separate group for each month, automatically corresponding field and deselect the name of the
naming the group to match. For example, Excel group. If you select the items of the group from the
places all dates from January in the January box, the individual items display on the PivotTable
group and names the group Jan. without the corresponding group.

COLLAPSE GROUP AND ¤ Clicking Data ➪ Group ■ Excel hides all items
CREATE SUBTOTALS and Outline ➪ Hide Detail. within the selected group,
⁄ Select the group. and only the group totals
display.

133