Type Alias PivotCacheConsolidationSource

Describes the source of a pivot cache's data when it consolidates multiple ranges (via the legacy PivotTable Wizard).

type PivotCacheConsolidationSource = {
    autoPage?: boolean;
    pages?: string[][];
    rangeSets: PivotCacheConsolidationRangeSet[];
}

Properties

autoPage?: boolean

Whether Excel automatically creates page fields.

true

pages?: string[][]

Page fields. Each inner array is one page field's item names. Up to 4.

The source ranges being consolidated.