Skip to main content
Row

DevExpress v24.2 Update — Your Feedback Matters

Our What's New in v24.2 webpage includes product-specific surveys. Your response to our survey questions will help us measure product satisfaction for features released in this major update and help us refine our plans for our next major release.

Take the survey Not interested

PivotField Methods

Represents a field in a PivotTable report.
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