Advanced Microsoft® Office Documents 2007 Edition Inside Out

Managing PivotTables

So, you now have a basic PivotTable report. You can move fields around and examine your data in as many ways as you can logically combine the fields from your source data. But, chances are that you may want to customize things a bit more. The subsections that follow provide an overview of capabilities along with key tips for customizing field settings and table settings.

Field Settings

You can reorganize the layout of your table, customize field names, manage subtotal options, select formulas by which to present or summarize value fields, and sort or filter field results. You can do any of this through the Field Settings dialog box for the appropriate field type—but you don’t actually need a dialog box for most of it.

Between ...