March 2007
Intermediate to advanced
704 pages
21h 31m
English
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.
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 ...
Read now
Unlock full access