PivotPageFields class

PivotPageFields class

Represents the pivot page field items if the pivot table data source is consolidation ranges. It only can contain up to 4 fields.

The PivotPageFields type exposes the following members:

Constructors

ConstructorDescription
initRepresents the pivot page field items.

Properties

PropertyDescription
page_field_countGets the number of page fields.

Methods

MethodDescription
add_page_fieldAdds a page field.
add_identifySets 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.

See Also