Microsoft Office Tutorials and References
In Depth Information
Why It’s Called a PivotTable
You will see the cells in the Values area
formatted as Currency. Recall that earlier,
the item named Hats was selected in the
Report Filter area. Go ahead and click
the filter icon in cell I2, select the All item,
and click OK, as indicated in Figure 15-13.
You’ll see that the PivotTable report is now
fully displayed, with all the Values area cells
formatted as Currency, including the cells
that had been hidden while the Hats item
Why it’s called a pivotTable
One of the most attractive features of a PivotTable is its ability to display the same data in whatever
row-and-column arrangement of your field names that you prefer. Just as the essence of a pivot is
to allow for the rotation or maneuver from a central point, you can rearrange your source data by
varying the location of your field names in the row and column areas of your PivotTable.
For example, since you have summarized the clothing stores by Revenue for each Region by
Quarter, you now want to look at the Quantity of each Item that was sold by Region. Reopen the
PivotTable Field List and pivot your data by dragging the Item field name out of the Report Filter
pane and into the Row Labels pane. Relocate the Regions field into the Column Headers pane.
Finally, in the Choose Fields to Add to Report pane, deselect Revenue and select Quantity. Your new
PivotTable report will look like Figure 15-14.