Microsoft Office Tutorials and References
In Depth Information
So far, all the fields by which we’ve filtered the PivotTable have changed the
organization of the data in the PivotTable. Adding some fields to a PivotTable, however, might
create unwanted complexity. For example, you might want to filter a PivotTable by
weekday, but adding the Weekday field to the body of the PivotTable expands the
table unnecessarily.
Instead of adding the Weekday field to the Row Labels or Column Labels area, you can
drag the field to the Report Filter area near the bottom of the PivotTable Field List task
pane. Doing so leaves the body of the PivotTable unchanged, but adds a new area above
the PivotTable in its worksheet.
Search JabSto ::




Custom Search