| Constructor Summary |
|---|
PivotPageFields()
Represents the pivot page field items. |
| Property Getters/Setters Summary | ||
|---|---|---|
function | getPageFieldCount() | |
| Gets the number of page fields. | ||
| Method Summary | ||
|---|---|---|
function | addIdentify(rangeIndex, pageItemIndex) | |
| Sets which item label in each page field to use to identify the data range. The pageItemIndex.Length must be equal to PageFieldCount, so please add the page field first. | ||
function | addPageField(pageItems) | |
| Adds a page field. | ||
| Constructor Detail |
|---|
function PivotPageFields()
| Property Getters/Setters Detail |
|---|
getPageFieldCount : Number | |
function getPageFieldCount() | |
| Method Detail |
|---|
addPageField | |
function addPageField(pageItems) | |
pageItems: String[] - Page field item labeladdIdentify | |
function addIdentify(rangeIndex, pageItemIndex) | |
rangeIndex: Number - The consolidation data range index.pageItemIndex: Number Array - The page item index in the each page field.
pageItemIndex[2] = 1 means the seconde item in the third field to use to identify this range.
pageItemIndex[1] = -1 means no item in the second field to use to identify this range
and MS will auto create "blank" item in the second field to identify this range.