Skip to main content
Row

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