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 | Gets or sets a format string used to display numeric values (e.g., dates or times) within the PivotTable field. |
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