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