Microsoft Office Tutorials and References
In Depth Information
Grouping the Data
Figure 8–55. Aggregating by months discloses important patterns in sales activity
I’d say that’s pretty cool—and useful. The pivot report has combined, or aggregated, the dates into
a larger category, in this case months, thus enabling us to break out the sales data by that unit. You
could also select both Years and Months i n the G r oupi n g di al og box by way of addi ti on al e xampl e ,
whe r e upon the data woul d be br oke n out by y e ar , an d the n by mon ths be l ow e ach y e ar . An d i f we wan t
to return the data to their original state, just click in the Row Labels area and repeat the above
command sequence, substituting Ungroup Group .
The grouping option can also be productively applied to standard numerical data in addition to
dates, provided those data are placed in the Row or Column areas. For example-I could place the Order
Amount data in the Row Label area—something we’ve yet to do, because these kinds of data are
usually sent to the Values area to be added, averaged, etc. But if I do go ahead and assign Order
Amount to the Row Labels area, I’ll see, at least in part (Figure 8–56):
Figure 8–56. Listed numbers: Each transaction sum, arrayed in the row label area
True to Row Label form, the data here are merely listed uniquely (and that means if two sales came
to say, $50 each, that number would be listed only once). Now, if I click the Group Selection comman d,
I’ll see (Figure 8–57):
 
Search JabSto ::




Custom Search