PivotTables.CreateConsolidatedPivotTable(IEnumerable, Int32, Int32)

Introduced in build 8.6.1

Description

Creates a new PivotTable for multiple consolidated ranges. A PivotTable created by this method is part of PivotTables collection.

Parameters

data

The data that is represented within the PivotTable.

aRow

The 0-based number of the row of the upper left corner of the PivotTable.

aColumn

The 0-based number of the column of the upper left corner of the PivotTable.

Remarks

This constructor will create Row, Column, and Value as ?SourceFields.  These ?SourceFields will be created using the same algorithm that the Pivot Table Wizard in Excel uses to create Multiple Consolidation Pivot Tables.

Examples