Microsoft Office Tutorials and References
In Depth Information
Chapter 14: Using Pivot Tables
Figure 14-7: The PivotTable Fields List dialog box.
How do you want to view that? You want markets to go down the left side of the report and the sales
amount to be calculated next to each market. You need to add the Market field to the Row Labels
area and the Sales Amount field to the Values area.
1. In the fields list, select the Market field (see Figure 14-8).
Now that you have regions in your pivot table, it’s time to add the dollar sales.
Figure 14-8: Select the Market field to add it to the fields selector list.