We have updated Flexmonster Software License Agreement, effective as of September 30, 2024. Learn more about what’s changed.
All documentation
  • API Reference for older versions
  • expandAllData

    expandAllData(withAllChildren: Boolean, type: String)

    [starting from version: 1.4]

    Expands all fields and drills down all multilevel hierarchies in rows, columns, or rows and columns. Works for the grid and the charts.

    Parameters

    Parameter/TypeDescription
    withAllChildren
    Boolean
    optional Indicates whether multilevel hierarchies should be drilled down.
    Set it to false if you want to expand fields without the drill-down. When set to true, the drill-down is performed as well.
    Default value: true.
    type
    String
    optional Specifies where to expand fields and drill down multilevel hierarchies: in rows ("rows"), in columns ("columns"), or in rows and columns ("all").
    Default value: "all".

    Examples

    1) Expands all fields and drills down all multilevel hierarchies in the slice.

    pivot.expandAllData();

    Try the example on JSFiddle.

    2) Expands all fields in the slice but does not drill down multilevel hierarchies.

    pivot.expandAllData(false);

    3) Expands all fields and drills down all multilevel hierarchies in rows.

    pivot.expandAllData(true, "rows");

    See also

    expandData
    collapseAllData
    collapseData