Skip to main content

PivotField Members

Represents a field in a PivotTable report.

Properties

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.

Methods

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

PivotField Interface

DevExpress.Spreadsheet Namespace

Was this page helpful?

Thanks for your feedback!

How can we improve this help topic?

Add an example/code snippet.

Improve topic clarity.

Improve organization/make it easier to find.

Include additional information/content.

Additional comments/thoughts:

If you have any questions, submit a ticket to our Support Center.

No

Your feedback is appreciated.