PivotItem.Caption Property (Excel)
Returns a String value that represents the label text for the pivot item.
Syntax
expression .Caption
expression A variable that represents a PivotItem object.
Remarks
The following table shows example values of the Caption property and related properties, given an OLAP data source with the unique name "[Europe].[France].[Paris]" and a non-OLAP data source with the item name "Paris".
Property |
Value (OLAP data source) |
Value (non-OLAP data source) |
|---|---|---|
Paris |
Paris |
|
[Europe].[France].[Paris] (read-only) |
Paris |
|
[Europe].[France].[Paris] (read-only) |
(Same as the SQL property value; read-only) |
|
[Europe].[France].[Paris] (read-only) |
Paris |
When specifying an index into the PivotItems collection, you can use the syntax shown in the following table.
Syntax (OLAP data source) |
Syntax (non-OLAP data source) |
|---|---|
expression.PivotItems("[Europe].[France].[Paris]") |
expression.PivotItems("Paris") |
When using the Item property to reference a specific member of a collection, you can use the text index names shown in the following table.
Name (OLAP data source) |
Name (non-OLAP data source) |
|---|---|
[Europe].[France].[Paris] |
Paris |