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/Type	Description
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"`.

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");