PivotField Properties

Represents a field in a PivotTable report.

Name	Description
Axis	Returns the region of the pivot table where the current field is displayed.
Behavior	Provides access to an object that allows you to restrict operations with the current PivotTable field.
CalculatedItems	Provides access to the collection of calculated items added to the PivotTable field.
Formula	Gets or sets the formula for the calculated field.
GroupingInfo	Provides access to the PivotFieldGroupingInfo interface which provides information on grouping applied to the field.
IncludeNewItemsInFilter	Gets or sets a value indicating whether new items should appear in the field when manual filtering is applied to it.
Items	Provides access to the collection of items in the specified PivotTable field.
Layout	Provides access to settings used to adjust the layout of the PivotField object.
Name	Gets or sets the PivotTable field’s name.
NumberFormat	Specifies a number format (in the invariant culture) used to display numeric values (for example, date and time) within the PivotTable field.
NumberFormatLocal	Specifies a local number format used to display numeric values (for example, date and time) within the PivotTable field.
ShowHeaderDropDown	Specifies whether or not to show a drop-down button on the field header.
Sort	Provides access to the sort options of the PivotTable field.
SortType	Gets or sets the type of sort to apply to the PivotTable field.
SourceName	Gets the name of the pivot field as it appears in the PivotTable’s source data.
SubtotalCaption	Gets or sets the text to be displayed in the field’s subtotal row or column heading.
SubtotalFunctions	Gets the function(s) used to subtotal the PivotTable field.
SubtotalType	Gets the type of subtotals displayed for the PivotTable field.