Microsoft Office Tutorials and References
In Depth Information
Creating a Pivot Table
h If you add a field to the Report Filter section, the field items appear in a drop-down list,
which allows you to filter the displayed data by one or more items. Figure 18-12 shows an
example. I dragged the Date field to the Report Filter area. The report is now showing the
data only for a single day (which I selected from the drop-down list).
Figure 18-11: Two fields are used for row labels.
Figure 18-12: The pivot table is filtered by date.