Member Junction
    Preparing search index...

    Interface PivotMeasureColumn

    Configuration for a single measure column in a pivot operation.

    interface PivotMeasureColumn {
        Aggregation?: PivotAggregationType;
        CurrencyColumn?: string;
        Format: PivotMeasureFormat;
        Key: string;
        Label: string;
    }
    Index

    Properties

    Aggregation? CurrencyColumn? Format Key Label

    Properties

    Aggregation?: PivotAggregationType

    Aggregation function to apply (defaults to 'sum')

    CurrencyColumn?: string

    For a 'currency' measure: the row column holding each amount's ISO 4217 currency code. The pivot also groups by this column, so amounts in different currencies are never summed into one figure, and each group is formatted in its own currency. Omit for single-currency data, which is then formatted as USD.

    Format: PivotMeasureFormat

    Format style for rendering the aggregated value

    Key: string

    The field name/key from the raw query dataset

    Label: string

    The column header label to display

    Settings

    Member Visibility

    On This Page

    Properties