Skip to main content
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.
Position Returns or specifies the item position within the field’s item collection.
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