Name | Description | |
---|---|---|
AllItemsVisible | Retrieves a value that indicates whether any manual filtering is applied to Pivotfield. | |
AutoSortField | Returns the name of the data field used to sort the specified PivotTable field automatically. | |
AutoSortOrder | Returns the order used to sort the specified PivotTable field automatically. | |
BaseField | Gets or sets the base field for a custom calculation. This property is valid only for data fields. | |
BaseItem | Gets or sets the item in the base field for a custom calculation. Valid only for data fields. | |
Calculation | Gets or sets a PivotFieldCalculation value that represents the type of calculation performed by the specified field. This property is valid only for data fields. | |
CurrentPage | Gets or sets the current page's index showing for the page field (valid only for page fields). The valid value is based on zero. "-1" indicates "All" or "Multiple Items". | |
DragToColumn | Gets or sets whether the specified field can be dragged to the column position. The default value is True. | |
DragToData | Gets or sets whether the specified field can be dragged to the data position. The default value is True. | |
DragToHide | Gets or sets whether the field can be hidden by being dragged off the PivotTable report. The default value is True. | |
DragToPage | Gets or sets whether the field can be dragged to the page position. The default value is True. | |
DragToRow | Gets or sets whether the field can be dragged to the row position. The default value is True. | |
EnableMultiplePageItems | Gets or sets whether the field can have multiple items selected in the page field. The default value is false. | |
Formula | Returns or sets a String value that represents the object's formula in A1-style notation and in the language of the macro. | |
Function | Gets or sets the function used to summarize the PivotTable field (data fields only). This object is read or write. | |
LayoutBlankLine | True if a blank row is inserted after the specified row field in a PivotTable report. The default value is False. | |
LayoutCompactRow | Specifies whether or not a PivotField is compacted(items of multiple PivotFields are displayed in a single column) when rows are selected. | |
LayoutForm | Returns or sets the way the specified PivotTable items appear — in table format or in outline format. | |
LayoutSubtotalLocation | Gets or sets the position of the PivotTable field subtotals in relation to (either above or below) the specified field. | |
Name | Gets or sets the name of the object (read or write). | |
NumberFormat | Gets or sets the format code for the object. | |
Orientation | Gets or sets the location of the field in the specified PivotTable report. | |
PivotFilters | Get the filter set of the current IPivotField. | |
PivotItems | Returns a collection of all the visible and hidden items in the specified field. | |
Position | Gets or sets the position of the field (first, second, third, and so on) among all the fields in its orientation (Rows, Columns, Pages, Data). | |
RepeatLabels | Gets or sets whether item labels are repeated in the PivotTable for the specified PivotField. | |
ShowAllItems | True if all items in the PivotTable report are displayed, even if they don’t contain summary data. The default value is False. | |
SourceName | Returns the specified object’s name as it appears in the original source data for the specified PivotTable report. This might be different from the current item name if the user renamed the item after creating the PivotTable report. | |
Subtotals | Gets or sets a combination of all the showing subtotal types in the specified PivotField. Valid only for nondata fields. |