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.

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.