Keywords: Pivot Table, Multiple Consolidation, Accounting, Tutorial
Description: Use the multiple consolidation range feature of PivotTables to summarize accounting data arranged in columns by month. Summarize the PivotTable by quarter using the built-in PivotTable grouping feature.
Tip: Use the multiple consolidation range feature of pivot tables to summarize accounting data arranged in columns by month. The pivot table data can be summarized by quarter using the built-in pivot table grouping feature. Each page of data included in the pivot table can be assigned a unique identifier in a new page field that is created when you define the pivot table.
Guide to the Example:
Use the pivot table wizard button on the query and pivot tool bar
to "look inside" the definition of the pivot table.
Select a cell in the pivot table, click on the wizard button and
use the prior and next buttons to move through all screens of the
definition.
Download File: Click Here
Tip: Click on the link above and choose
"Save" to download the xls workbook to your hard drive or "Open" to
open the workbook inside of your browser.
