Microsoft Office Tutorials and References
In Depth Information
To demonstrate the flexibility of pivot tables, I created some additional pivot tables. The examples use the bank
account data and answer the questions posed earlier in this chapter (see the “A Pivot Table Example” section).
What is the daily total new deposit amount for each branch?
Figure 18-14 shows the pivot table that answers this question.
• The Branch field is in the Columns section.
• The Date field is in the Rows section.
• The Amount field is in the Value section and is summarized by Sum.
Note that the pivot table can also be sorted by any column. For example, you can sort the Grand Total column in
descending order to find out which day of the month had the largest amount of new funds. To sort, just right-
click any cell in the column to sort and choose Sort from the shortcut menu.