Pivot Item Properties

Name

Returns

Description

Caption

String

Set/Get the label text associated with the item

ChildItems

Variant

Read-only. Parameters: [Index] . Returns an object or collection containing a single PivotTable item (PivotItem) or group of PivotTable items (PivotItems) associated with the item

DataRange

Range

Read-only. Returns a range containing the data or items in the item

DrilledDown

Boolean

Set/Get whether the PivotTable item is drilled down

Formula

String

Set/Get the formula associated with item, if any

IsCalculated

Boolean

Read-only. Returns whether the item that was calculated is a data item

LabelRange

Range

Read-only. Returns the cell range containing the field's item

Name

String

Set/Get the name of the item

ParentItem

PivotItem

Read-only. Returns the parent item of the current item, if any

Name Returns Description

ParentShowDetail Boolean Read-only. Returns whether the current item is being shown because the one of the item's parents is set to show detail

Position Long Set/Get the position number of the item among all the items in the same orientation

RecordCount Long Read-only. Returns the number of records in the

PivotTable cache that contain the item

ShowDetail Boolean Set/Get whether the detail items are being displayed

SourceName Variant Read-only. Returns the name of the source data for the item

SourceName String Read-only. Returns the Pivotltem's source name in

Standard standard U.S. format settings

StandardFormula String Set/Get the formulas with standard U.S. formatting

Value String Set/Get the name of the specified item

Visible Boolean Set/Get whether the item is visible

0 0

Responses

  • sagramor
    How to read caption property of parent pivotitem in vba?
    2 years ago

Post a comment