For example, if you're consolidating budget data from the Marketing, Sales, and Manufacturing departments, a page field can include one item to show the data for each department, plus an item to show the combined data. The following example shows four ranges in cross-tab format.ĭata consolidation can use page fields that contain items representing one or more of the source ranges.
Do not include any total rows or total columns from the source data when you specify the data for the report. Setting up the source dataĮach range of data should be arranged in cross-tab format, with matching row and column names for items that you want to summarize together. In addition, the report can have up to four page filter fields, called, ,, and. The resulting consolidated PivotTable report can have the following fields in the PivotTable Field List, which you can add to the PivotTable: Row, Column, and Value. When you consolidate data, you are assembling it so that you can more easily update and aggregate data regularly or as needed. The separate worksheet ranges can be in the same workbook as the master worksheet or in a different workbook. To summarize and report results from separate worksheet ranges, you can consolidate data from each separate worksheet range into a PivotTable on a master worksheet.
