PivotField Methods
Represents a field in a PivotTable report.
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