Excel 2016 Tips and Tricks

Excel 2016

Lesson – Creating/Revising PivotTables



S TEP - BY -S TEP Delete a PivotTable report field.

If necessary, display the Sheet1 worksheet.

Steps

Practice Data

Click

SalesRep to

1. In the PivotTable Field pane, deselect the check box for the field you want to remove. The field is removed from the PivotTable report.

deselect it

C REATING R EPORT F ILTER P AGES  D ISCUSSION You can use the Show Report Filter Pages feature to create a separate PivotTable report for each item in a report filter field. This feature creates a copy of the PivotTable report in a new worksheet for each report filter field item. For example, if you have a Region report filter field, and you select the Show Report Filter Pages feature, a separate worksheet is created for each region in the Region report filter field list.

Report filter pages are inserted before the original PivotTable report worksheet.

Viewing Report Filter Pages for all regions

OFFICEPRO, Inc.

Page 117