Microsoft Office Tutorials and References
In Depth Information
Figure 18-19: This pivot table (and pivot chart) compares the Central branch with the other two branches com-
I selected the North County and Westside labels, right-clicked, and chose Group to combine those two branches
into a new category. Grouping also creates a new field in the PivotTable Fields task pane. In this case, the new
field is named Branch2. I changed the label in the pivot table to Other Branches.