After you select to roll the dates up to Month, Quarter, and Year, an interesting thing happens. Before the operation, you had a PivotField named ShipDate that was grouped by day. We still have a PivotField named ShipDate, but this field is now grouped by month. Two new fields are available in the PivotTable Field list: Years and Quarters. When you group dates, the least aggregated field always takes on the name of the underlying field. Any additional groupings are added as new fields to the Field list.

The new summary and the new field names are shown in Figure 12.31.

Figure 12.31

The Pivot Table quickly summarized the daily information by month, quarter,and year.

G h

1 j

0 0

Post a comment