.
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.
C#
vb.net
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
C#
vb.net