@jsfkit/types
    Preparing search index...

    Type Alias PivotCacheField

    Describes a field (column) in a pivot cache. Each cache field corresponds to a column in the source data range.

    type PivotCacheField = {
        databaseField?: boolean;
        fieldGroup?: PivotCacheFieldGroup;
        formula?: string;
        name: string;
        numFmt?: string;
        sharedItems?: PivotCacheSharedItem[];
        sharedItemsMeta?: PivotCacheSharedItemsMeta;
    }
    Index

    Properties

    databaseField? fieldGroup? formula? name numFmt? sharedItems? sharedItemsMeta?

    Properties

    databaseField?: boolean

    Whether this field comes from the source database. When false, the field is a calculated field not present in the original data source.

    true
    fieldGroup?: PivotCacheFieldGroup

    Grouping information for this field (date ranges, numeric ranges, or discrete groups).

    formula?: string

    A formula for a calculated field, expressed in A1-style notation.

    name: string

    The name of the field, typically matching the column header in the source data.

    numFmt?: string

    The number format code for this field's values (e.g. "General", "#,##0").

    sharedItems?: PivotCacheSharedItem[]

    The unique values found in this field's source data. Used for item indexing in pivot cache records and pivot field items.

    sharedItemsMeta?: PivotCacheSharedItemsMeta

    Metadata about the shared items or record-level values for this field. When sharedItems is populated, this can be derived from the items; when absent, it preserves type/range information that would otherwise be lost.

    Settings

    Member Visibility

    On This Page

    Properties