The requested page is not available for the requested platform. You are viewing the content for .NET Framework 4.5.2+ platform.
.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
.NET Core 3.0+
Row

PivotItem Members

Represents an item in a PivotTable field.

Properties

Name Description
Caption

Gets or sets the label text for the pivot item.

Formula

Gets or sets the formula for the calculated item.

ShowDetails

Gets or sets a value indicating whether the outline is expanded for the pivot item.

Value

Gets the value of the item in the original source data.

Visible

Gets or sets a value indicating whether the item should be displayed in the report.

Methods

Name Description
MoveDown()

Moves the item to the next position within the field's item collection.

MoveToBeginning()

Moves the item to the first position within the field's item collection.

MoveToEnd()

Moves the item to the last position within the field's item collection.

MoveUp()

Moves the item to the previous position within the field's item collection.

See Also