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

PivotField Members

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.


Name Description
GroupItems(PivotFieldGroupByType) Performs grouping of the specified type in the current field.
GroupItems(PivotGroupingValue, PivotGroupingValue, Double, PivotFieldGroupByType) Performs field grouping using the specified grouping properties.
GroupItems(IEnumerable<Int32>) Groups the specified items in the field.
GroupItems(DateTime, DateTime, Int32, PivotFieldGroupByType) Performs grouping by dates in the specified interval.
GroupItems(Double, Double, Double) Performs numeric grouping in the current field.
SetSubtotal(PivotSubtotalFunctions) Specifies the function(s) to calculate subtotals for the PivotTable field.
SetSubtotalAutomatic() Displays automatic subtotals for the PivotTable field.
ShowAllItems() Displays all items in the PivotTable field.
ShowSingleItem(Int32) Displays the specified item in the PivotTable field.
SortItems(PivotFieldSortType, Int32, PivotItemReference[]) Sorts items in the current pivot field based on values in the specified data field.
SortItems(PivotFieldSortType, Int32, IEnumerable<PivotItemReference>) Sorts items in the current pivot field based on values in the specified data field.
UngroupItems() Removes grouping for the current field.
UngroupItems(IEnumerable<Int32>) Removes the specified items from grouping.
See Also