PivotField object (Excel)

Represents a field in a PivotTable report.

Remarks

The PivotField object is a member of the PivotFields collection. The PivotFields collection contains all the fields in a PivotTable report, including hidden fields.

In some cases, it may be easier to use one of the properties that returns a subset of the PivotTable fields. The following properties are available:

Example

Use PivotFields ( index ), where index is the field name or index number, to return a single PivotField object. The following example makes the Year field a row field in the first PivotTable report on Sheet3.

Worksheets("sheet3").PivotTables(1) _ 
 .PivotFields("year").Orientation = xlRowField

Methods

Name
AddPageItem
AutoShow
AutoSort
CalculatedItems
ClearAllFilters
ClearLabelFilters
ClearManualFilter
ClearValueFilters
Delete
DrillTo
PivotItems
AutoGroup

Properties

Name
AllItemsVisible
Application
AutoShowCount
AutoShowField
AutoShowRange
AutoShowType
AutoSortCustomSubtotal
AutoSortField
AutoSortOrder
AutoSortPivotLine
BaseField
BaseItem
Calculation
Caption
ChildField
ChildItems
Creator
CubeField
CurrentPage
CurrentPageList
CurrentPageName
DatabaseSort
DataRange
DataType
DisplayAsCaption
DisplayAsTooltip
DisplayInReport
DragToColumn
DragToData
DragToHide
DragToPage
DragToRow
DrilledDown
EnableItemSelection
EnableMultiplePageItems
Formula
Function
GroupLevel
Hidden
HiddenItems
HiddenItemsList
IncludeNewItemsInFilter
IsCalculated
IsMemberProperty
LabelRange
LayoutBlankLine
LayoutCompactRow
LayoutForm
LayoutPageBreak
LayoutSubtotalLocation
MemberPropertyCaption
MemoryUsed
Name
NumberFormat
Orientation
Parent
ParentField
ParentItems
PivotFilters
Position
PropertyOrder
PropertyParentField
RepeatLabels
ServerBased
ShowAllItems
ShowDetail
ShowingInAxis
SourceCaption
SourceName
StandardFormula
SubtotalName
Subtotals
TotalLevels
UseMemberPropertyAsCaption
Value
VisibleItems
VisibleItemsList

See also

Excel Object Model Reference