PivotField Members
In This Article
#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 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 |
#Methods
Name | Description |
---|---|
Group |
Performs grouping of the specified type in the current field. |
Group |
Performs field grouping using the specified grouping properties. |
Group |
Groups the specified items in the field. |
Group |
Performs grouping by dates in the specified interval. |
Group |
Performs numeric grouping in the current field. |
Set |
Specifies the function |
Set |
Displays automatic subtotals for the Pivot |
Show |
Displays all items in the Pivot |
Show |
Displays the specified item in the Pivot |
Sort |
Sorts items in the current pivot field based on values in the specified data field. |
Sort |
Sorts items in the current pivot field based on values in the specified data field. |
Ungroup |
Removes grouping for the current field. |
Ungroup |
Removes the specified items from grouping. |
See Also