Chapter 22: PivotTable
Author: Joseph Rubin, CPA www.exceltip.com
You cannot group according to Number of Days and also
according to months, quarters or years in the same PivotTable.
If you group by Number of Days, the date groups that you
created earlier become ungrouped (the three new groups that
you created are removed). You cannot simultaneously group
according to Number of Days and insert the three new
columns of months, quarters and years.
If you want to save the PivotTable with grouping by days and
grouping by months, quarters and/or years, you must
construct an additional PivotTable (see explanation later in
this chapter on inserting additional PivotTables into the
Grouping dates by weeks
You will certainly want to create groups of seven days that begin with the
first day of the week. To do so, you must locate the first Monday of the
data table and define it as a date to begin grouping the dates.
Often, the location of the first Monday will be before the first date of the
data table. For example, the first date of
the data table is 5/10/1996. To
determine if this is a Monday:
1. In any cell outside the PivotTable,
enter the date 5/10/96.
2. Select the cell and press Ctrl+1
3. Select the Number tab.
4. Select Custom.