PivotTable Fundamentals - Microsoft Business Intelligence Tools for Excel Analysts - page 20

Figure 2-5: Add the Sales Amount field.
When you add new fields, you may find it difficult to see all the fields in the box for each area. You can
expand the PivotTable Fields List pane by clicking and dragging the borders of the pane.
As you can see, you have just analyzed the sales for each market in just a few steps! That's an amazing
feat considering you start with over 60,000 rows of data. With a little formatting, this modest
PivotTable can become the starting point for a dashboard or report.
Modifying the PivotTable
Here's the wonderful thing about PivotTables: For your data model, you can add as many analysis
layers as you like by changing or rearranging the fields in your source data table. Say you want to
show the dollar sales each market earned by business segment. Because your PivotTable already con-
tains the Market and Sales Amount fields, all you have to add is the Business Segment field.
Click anywhere in your PivotTable to open the PivotTable Fields List pane and then select the
Business Segment field to add it to the Rows area. Figure 2-6 shows what your PivotTable now
looks like.
What if this layout doesn't work for you? Maybe you want to see business segments listed at the top
of the PivotTable results. No problem. Simply drag the Business Segment field from the Rows area to
the Columns area. As shown in Figure 2-7, this instantly restructures the PivotTable to your
specifications.