Share this Page URL

Chapter 11. Analyzing Data with PivotTab... > Using a PivotChart to Display and An... - Pg. 396

Analyzing Data with PivotTables and PivotCharts 396 9. The Behavior tab includes options that let you control, for example, whether detail items are always expanded or always collapsed when you open the PivotTable. You can also hide el- ements of a PivotTable using options on this tab. The Report tab has an option that we men- tioned earlier--that totals will include all items, not only the items that are visible. If you select the option to include all items, the PivotTable displays an asterisk (*) beside the caption of the total field to indicate that hidden items are included. Close the ProductsByCountry PivotTable. Exporting a PivotTable to Microsoft Excel If you want to work with a PivotTable you've created in Access in Microsoft Excel, use the Export To Microsoft Excel button on the PivotTable toolbar. Calculated fields you created in Access aren't exported, and the Piv- otTable in Excel might not display all the levels of detail. If you copy data displayed in a PivotTable and paste it into Excel or Microsoft Word, you'll see only the rows and columns that were visible when you copied the data. Hidden data or data not shown because of a filter you've applied isn't copied. Just the Steps Work with PivotTable properties and formats 1. 2. 3. 4. 5. 6. Open the PivotTable form. On the PivotTable toolbar, click Properties. On the Format tab of the Properties dialog box, select the PivotTable element you want to work with. Use the Captions tab to enter and format a caption for a PivotTable field. Use the Behavior tab to control whether a PivotTable displays detailed data by default. Use the Report tab to specify whether calculated totals are based on visible items only or on all items.