PivotField.AddPageItem (Excel)

Adds an additional item to a multiple item page field.

To avoid run-time errors, the data source must be an OLAP source, the field chosen must currently be in the page position, and the EnableMultiplePageItems property must be set to True.

AddPageItem (Item, ClearList)

Dim strItem As String: strItem =  "[Product].[All Products].[Food].[Eggs]"
ActiveCell.PivotField.AddPageItem Item:=strItem

Arguments

The following argument is required

Item (String) - Source name of a PivotItem object, corresponding to the specific Online Analytical Processing (OLAP) member unique name.

Optional arguments

The following argument is optional

ClearList (Boolean) - If False (default), adds a page item to the existing list. If True, deletes all current items and adds Item.