officefileapi-devexpress-dot-spreadsheet-dot-pivotfield-dot-underscore-members.md
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 | 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. |
| 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