PivotField Properties
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 Pivot |
Calculated |
Provides access to the collection of calculated items added to the Pivot |
Formula | Gets or sets the formula for the calculated field. |
Grouping |
Provides access to the Pivot |
Include |
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 Pivot |
Layout |
Provides access to settings used to adjust the layout of the Pivot |
Name |
Gets or sets the Pivot |
Number |
Specifies a number format (in the invariant culture) used to display numeric values (for example, date and time) within the Pivot |
Number |
Specifies a local number format used to display numeric values (for example, date and time) within the Pivot |
Show |
Specifies whether or not to show a drop-down button on the field header. |
Sort |
Provides access to the sort options of the Pivot |
Sort |
Gets or sets the type of sort to apply to the Pivot |
Source |
Gets the name of the pivot field as it appears in the Pivot |
Subtotal |
Gets or sets the text to be displayed in the field’s subtotal row or column heading. |
Subtotal |
Gets the function |
Subtotal |
Gets the type of subtotals displayed for the Pivot |
See Also