PivotLabel (Object)

Member of:

Pivot Labels collection

Description:

Represents a top or side label in a Pivot report.

Example:

This example shows how to size the height and width of pivot labels automatically, and how to hide pivot facts:

Documents["Sample 1.bqy"].Sections["SalesPivot"].Facts["Unit Sales"].AutoSizeHeight()
Documents["Sample 1.bqy"].Sections["SalesPivot"].Facts["Unit Sales"].AutoSizeWidth()
Documents["Sample 1.bqy"].Sections["SalesPivot"].Facts["Unit Sales"].Hide()

Methods:

AddTotals(), AutoSizeHeight(), AutoSizeWeight(), PivotTo([Index As Number]), Remove(), SortByFact(FactName As String, SortFunction As BqSortFunction, [optional] SortOrder As BqSortOrder), SortByLabel([SortOrder As BqSortOrder])

Properties:

Read-only: Property Name as String, Property SortFactName As String, Property SortFunction As BqSortFunction, Property SortOrder As BqSortOrder

Read-write: Property Index as Number,

Collections:

LabelValues As Pivot, TopLabels and SideLabel collections