Microsoft Office Tutorials and References
In Depth Information
Figure 12-12 Aiming the mouse pointer at a data point in the values section displays a
ScreenTip with additional information.
Swap the row and column labels to get a completely different summary of the same data.
When we drag the Station field to the Row Labels section and move the Month field to
the Column Labels section, this result allows us to focus on totals by month instead of by
For this iteration, we also added the Day field to the Report Filter section (above the rest
of the report). To make the PivotTable more readable, we changed the name of the value
field (displayed in the upper left corner of the table) and hid the drop-down lists for
filtering rows and columns by clicking the Field Headers button in the Show group on the
PivotTable Tools Options tab.
You might also want or need to make some basic adjustments to field settings. To change
settings for the active field, use the Field Settings button in the Active Field group on the
Options tab. Or click the field button in the Values section of the PivotTable Fields List pane
and then click Value Field Settings to display the dialog box shown next.