PivotTable.ShowPageMultipleItemLabel Property

When set to True (default), "(Multiple Items)" will appear in the PivotTable cell on the worksheet whenever items are hidden and an aggregate of non-hidden items is shown in the PivotTable view. Read/write Boolean.

Syntax

expression.ShowPageMultipleItemLabel

expression   A variable that represents a PivotTable object.

Example

This example determines if "(Multiple Items)" will be displayed in the PivotTable cell and notifies the user. The example assumes that a PivotTable exists on the active worksheet.

  Sub UseShowPageMultipleItemLabel()
Dim pvtTable As PivotTable

Set pvtTable = ActiveSheet.PivotTables(1)

' Determine if multiple items are allowed.
If pvtTable.<strong class="bterm">ShowPageMultipleItemLabel</strong> = True Then
    MsgBox "The words 'Multiple Items' can be displayed."
Else
    MsgBox "The words 'Multiple Items' cannot be displayed."
End If

End Sub

See Also

• PivotTable Object
• PivotTable Members