PivotFact (Object)

Member of:

PivotFacts collection

Description:

Represents a fact item in a pivot.

Example:

This example shows how to show and autosize the height and width of the Unit Sales fact item:

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"].UnHide()

Methods:

AutoSizeHeight(), AutoSizeWidth(), Hide(), Remove(), UnHide()

Properties:

Read-write: Property DataFunction As BqDataFunction, Property Index As Number, Property NumberFormat As String

Read-only: Property Name as String