PivotField Properties

Preserves the sorting elements of the field

Gets/sets field axis.

User can remove field from view.

User can drag field to column area.

True if the specified field can be dragged to the data position. The default value is True.

User can drag field to page area.

User can drag field to row area.

Specifies the unique name of the member property to be used as a caption for the field and field items.

Specifies a boolean value that indicates whether the application will display fields compactly in the sheet on which this PivotTable resides

Gets/sets pivot field custom name.

Gets/sets value indicating whether this is data field.

Specifies the formula for the calculated field

Autoshow is enabled.

Gets/sets value indicating whether this is data field.

User can remove field from fiew.

Indicates whether this field is formula field

Specifies a boolean value that indicates whether the field can have multiple items selected in the page field.

Show all items for this field.

Specifies the number of items showed per page in the PivotTable.

Returns pivot field name. Read-only.

Gets/sets number format.

Gets / sets number format index.

Gets the parent PivotTableFields object of the current instance.

True if the field repeat item labels.

True if a blank row is inserted after the specified row field in a PivotTable report.

Gets or sets the show data as.

True if the flag for the specified PivotTable field or PivotTable item is set to "drilled" (expanded, or visible).

Specifies a boolean value that indicates whether manual filter is in inclusive mode.

Specifies a boolean value that indicates whether new items that appear after a refresh should be hidden by default.

Specifies a boolean value that indicates whether the items in this field should be shown in Outline form. If the parameter is true, the field layout is "Show item labels in outline form". If the parameter is false, the field layout is "Show item labels in tabular form".

True if a page break is inserted after each field.

Specifies a boolean value that indicates whether to show the property as a member caption.

Specifies a boolean value that indicates whether to show the member property value in a tooltip on the appropriate PivotTable cells.

Specifies the type of sort that is applied to this field.

Specifies the custom text that is displayed for the subtotals caption.

Gets or sets type of field subtotals.

Get or set whether show