Microsoft Office Tutorials and References
In Depth Information
Grouping the Data
Figure 8–57. Grouping this time by the sales order amounts
The Grouping dialog box here records the highest and lowest values among all the sales—a
spanand a suggested grouping interval, which we’ll accept. (Note: By typing a larger value, say 100, in
Starting at: , y ou ca n r e str i ct the g r oupi n g to be g i n a t the v al ue you’ve designated. The sub-100 values
will also be grouped, but in a “<100 category”.) By clicking OK, we get (Figure 8–58):
Figure 8–58. Big bucks: The transaction data, grouped in intervals of $1000
See what happens? The pivot report aggregated, or grouped , the sales order data by units of $1000
(Note: These aggregated intervals cannot be reformatted). If we then drag the same Order Amounts
field into the Values area—where it usually goes—but change its mathematical operation to Count , we
wind up with this (Figure 8–59):
Search JabSto ::

Custom Search