PivotField Methods (Excel)

This object has the following methods:

Name

Description

AddPageItem

Adds an additional item to a multiple item page field.

AutoShow

Displays the number of top or bottom items for a row, page, or column field in the specified PivotTable report.

AutoSort

Establishes automatic field-sorting rules for PivotTable reports.

CalculatedItems

Returns a CalculatedItems collection that represents all the calculated items in the specified PivotTable report. Read-only.

ClearAllFilters

Calling this method deletes all filters currently applied to the PivotField. This includes deleting all filters from the PivotFilters collection of the PivotField and removing any manual filtering applied to the PivotField as well. If the PivotField is in the Report Filter area, the item selected will be set to the default item.

ClearLabelFilters

This method deletes all label filters or all date filters in the PivotFilters collection of the PivotField.

ClearManualFilter

Provides an easy way to set the Visible property to True for all items of a PivotField in PivotTables, and to empty the HiddenItemsList and VisibleItemsList collections in OLAP PivotTables.

ClearValueFilters

Calling this method deletes all value filters in the PivotFilters collection of the PivotField.

Delete

Deletes the object.

DrillTo

The DrillTo method supports drilling to a specified PivotField from another PivotField.

PivotItems

Returns an object that represents either a single PivotTable item (a PivotItem object) or a collection of all the visible and hidden items (a PivotItems object) in the specified field. Read-only.

Show:
© 2015 Microsoft