PivotField and PivotFields Members

Use the PivotFields collection to get fields from a pivot table. Use the PivotTable object’s PivotFields, PageFields, ColumnFields, RowFields, DataFields, or HiddenFields properties to get a reference to this collection. Use the PivotField object to set the layout of a pivot table, to filter and sort items, and to get the items in a field. The PivotFields collection and PivotField object have the following members . Key members (shown in bold) are covered in the following reference section:

1 Collection only

2 Object and collection

AddPageItem

Application 2

AutoShow

AutoShowCount

AutoShowField

AutoShowRange

AutoShowType

AutoSort

AutoSortField

AutoSortOrder

BaseField

BaseItem

CalculatedItems

Calculation

Caption

ChildField

ChildItems

Count 1

Creator 2

CubeField

CurrentPage

CurrentPageList

CurrentPageName

DatabaseSort

DataRange

DataType

Delete

DragToColumn

DragToData

DragToHide

DragToPage

DragToRow

DrilledDown

EnableItemSelection

Formula

Function

GroupLevel

HiddenItems

HiddenItemsList

IsCalculated

IsMemberProperty

Item 1

LabelRange

LayoutBlankLine

LayoutForm

LayoutPageBreak

LayoutSubtotalLocation

MemoryUsed

Name

NumberFormat

Orientation

Parent 2

ParentField

ParentItems

PivotItems

Position

PropertyOrder

PropertyParentField

Get Programming Excel with VBA and .NET now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial