...
Introducedin | ||
---|---|---|
|
...
|
Description |
---|
Excerpt |
---|
Creates a new PivotTable for multiple consolidated ranges. A PivotTable created by this method is part of |
Signature | ||||
---|---|---|---|---|
| ||||
public PivotTable CreateConsolidatedPivotTable(IEnumerable<Area> data, int row, int column)
{signature}
{signature: |
Signature | ||||||
---|---|---|---|---|---|---|
| }
| |||||
Public Function CreateConsolidatedPivotTable(ByVal data As IEnumerable (of Area), ByVal row As Integer, ByVal column As Integer) As PivotTable
{signature}
{parameters}
{param:data}
The data that is represented within the PivotTable.
{param}
{param:aRow}
The 0-based number of the row of the upper left corner of the PivotTable.
{param}
{param:aColumn}
The 0-based number of the column of the upper left corner of the PivotTable.
{param}
{remarks}This constructor will create Row, Column, and Value as ?[EW8:SourceField]s. These ?{{SourceFields}} will be created using the same algorithm that the Pivot Table Wizard in Excel uses to create Multiple Consolidation Pivot Tables.
{remarks}
{example}
{code:csharp|title=C#} |
Parameters |
---|
Param | ||||
---|---|---|---|---|
| ||||
The data that is represented within the PivotTable. |
Param | ||||
---|---|---|---|---|
| ||||
The 0-based number of the row of the upper left corner of the PivotTable. |
Param | ||||
---|---|---|---|---|
| ||||
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 ? |
Example | ||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|