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:
- ColumnFields property
- DataFields property
- HiddenFields property
- PageFields property
- RowFields property
- VisibleFields property
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
- AddPageItem
- AutoGroup
- AutoShow
- AutoSort
- CalculatedItems
- ClearAllFilters
- ClearLabelFilters
- ClearManualFilter
- ClearValueFilters
- Delete
- DrillTo
- PivotItems
Properties
- 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
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.