Grouping Related Items U sing Two Fields

Up to now we've traveled the basic route to designing a PivotTable, in which one field in the Row Labels area breaks out the data in a field in the Values area. But you can also place two fields in the Row Labels area, to carry out a kind of double-breakout.

The PivotTable in Figure 8–25 illustrates what that means.

Figure 8–25. National pride: Sales, broken out both by country and salesperson

Here, the sales data is broken out by two fields, first by country and then by salesperson. We can see that 4 sales were conducted in the United Kingdom and 11 in the United States. Within the United Kingdom, it's Buchanan, Dodsworth, and Suyama who've compiled the sales, while Callahan, Davolio, Leverling, and Peacock have done their sales work in the States.