Part IV: Managing and Analyzing Data
FIGURE 29.17
This PivotTable uses a filter to show only the teller data.This PivotTable uses the OpenedBy field as a filter and is showing the data only for tellers.
Sort the rows so that the largest value is at the top by right-clicking any of the values,
choosing Sort, and choosing Sort Largest to Smallest. To display the data bars, use condi-
tional formatting.See Chapter 17 for more information about conditional formatting.In which branch do tellers open the most checking accounts for
new customers?
Figure 29.18 shows a PivotTable that answers this question. At the Central branch, tellers
opened 23 checking accounts for new customers.FIGURE 29.18
This PivotTable uses three filters.