PivotLabels (Collection)

Member of:

PivotSection object

Description:

Consists of the Pivot TopLabels and SideLabels collections. These collections correspond to the labels within a pivot section. These are columns added to the side and top labels groups in the outliner.

Tip:

All collections have the “Item(NameOrIndex)” method. This is the default method for all collections that returns collection items at a particular index or by name. Use brackets ([]) to represent calls to the Item (Method). For example, these statements are identical: myItem = Documents[1] myItem = Documents.Item(1) myItem = Documents["StartUp.bqy"] myItem = Documents.Item("StartUp.bqy")

Example:

This example shows how to add a number of request items to the side and top labels collections:

With(ActiveDocument.Sections["Pivot"])
{
          TopLabels.RemoveAll()
          SideLabels.RemoveAll()
          TopLabels.Add("Year")
          SideLabels.Add("Grape")
          SideLabels.Add("Winery")
}

Methods:

Add(RequestItemName As String, [optional] Index as Number As PivotLabel), Item(Value as NameOrIndex) As PivotLabel, RemoveAll()

Properties:

Read-only: Property Count As Number