Share this Page URL

Chapter 11. Analyzing Data with PivotTab... > Formatting a PivotTable and Setting ... - Pg. 394

Analyzing Data with PivotTables and PivotCharts 394 When you close the PivotTable, notice that even though we made a number of changes-- applying filters and pivoting columns and rows--Access doesn't prompt you to save the form. When you open the form again, the PivotTable will be arranged as it was when you closed it. Of course, if you've made any changes to the form in Design view, Access will prompt you to save those changes. Just the Steps Filter data in a PivotTable 1. 2. 3. When designing the PivotTable, add a field to the area labeled Drop Filter Fields Here. Click the down-arrow beside the filter field (or a column field), clear the All check box, and then select the item or items you want to use as filter criteria. Click the AutoFilter button on the PivotTable toolbar to display the complete set of records in the Pivot- Table again. Analyze data in a PivotTable Use the commands on the PivotTable menu (or buttons on the PivotTable toolbar) to analyze the data: · To display only a certain number or a certain percentage of the top or bottom values for a selected field, click Show Top/Bottom Items. · To calculate a subtotal or another aggregate value (Count or Average, for example), click the column heading for the data you're summarizing, click AutoCalc, and then select the function you want to use. · To insert a subtotal for a row of data, click Subtotal. · To add a calculated field or a calculated total, click Calculated Totals And Fields. In the Properties dialog box, enter the expression you want to use for the calculated total or field. · To view summary data such as a subtotal as a percentage of a grand total, click Show As, and then select the view you want.