.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+

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 Gets or sets a format string used to display numeric values (e.g., dates or times) 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.
See Also