Microsoft Office Tutorials and References
In Depth Information
Refreshing the PivotTable: Changing the Data
After clicking Group Selection, you’ll
see the dialog shown in Figure 8–35.
Figure 8–35. The Grouping dialog box: Organizing your
date data into the units of time you want
Then click Years (Months will remain
selected as well). If you don’t click
Years, all the January sales figures,
for example, will be totaled
together—and that might include
Januarys in different years (and the
same would of course apply to all
the other months). Click OK, and
you’ll see the display shown in
Figure 8–36.
Figure 8–36. Getting it all together: The data organized
by months and years
Now the sales data is grouped, and we can easily tell how sales have proceeded by
month. Again, while our database is small, grouping will work with any collection of
dates, no matter how large. To ungroup the data and return it to its original row label
appearance, just click within the date data and click Ungroup in the Group button group.
Refreshing the PivotTable: Changing the Data
So far our PivotTables have worked with the same 15-record database throughout, but
in the real world, of course, you may need to enter additional records and/or make
changes to existing ones, while at the same time seeing to it that your PivotTable results
reflect those changes. How does that happen?
Search JabSto ::

Custom Search