Skip to Content
Business Solutions Charts and Graphs for Microsoft® Office Excel® 2007
book

Business Solutions Charts and Graphs for Microsoft® Office Excel® 2007

by Bill Jelen
April 2007
Beginner to intermediate content levelBeginner to intermediate
480 pages
17h 6m
English
Que
Content preview from Business Solutions Charts and Graphs for Microsoft® Office Excel® 2007
275
Filtering a Pivot Table
Filtering Using a Report Filter Field
To add fields to the report filter, you drag them from the top of the PivotTable Field List
box to the Report Filter drop zone at the bottom of the PivotTable Field List box.
You can drag multiple fields to the Report Filter section. However, you cannot drag a field
that has already been used elsewhere in the pivot table.
For each field you add to the Report Filter section, you have a new drop-down in the
PivotChart Filter Pane box. When you initially open this drop-down, you can select only
one value from the drop-down. For example, you can select to filter the report to the east
region, ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Microsoft® Office Excel® 2007 Inside Out

Microsoft® Office Excel® 2007 Inside Out

Mark Dodge, Craig Stinson
What Successful Project Managers Do

What Successful Project Managers Do

W. Scott Cameron, Jeffrey S. Russell, Edward J. Hoffman, Alexander Laufer
How to Become a Game-Changing Leader

How to Become a Game-Changing Leader

Douglas A. Ready, Alan Mulally

Publisher Resources

ISBN: 0789736101Purchase book