Grid Layout

28 Sep 20172 minutes to read

Normal Layout

A layout in which summary cells are positioned at the bottom of each parent member and their child members appear next to them. Normal layout is the default layout in PivotGrid control. The enumeration property layout needs to be set to “ej.PivotGrid.Layout.Normal” in-order to view PivotGrid in normal layout.

HTML

<ej-pivotgrid [layout]="layout">
</ej-pivotgrid>

TS

export class PivotGridComponent {
    public layout;
    constructor() {
        //..
        this.layout = ej.PivotGrid.Layout.Normal; 
    }
}

No Summaries Layout

IMPORTANT

This feature is applicable only for OLAP datasource.

A layout in which summary cells are completely hidden and the child members appear next to their parent member. The enumeration property layout needs to be set to “ej.PivotGrid.Layout.NoSummaries” in-order to view PivotGrid without summaries.

TS

export class PivotGridComponent {
    public layout;
    constructor() {
        //..
        this.layout = ej.PivotGrid.Layout.NoSummaries; 
    }
}

Excel-like Layout

A layout in which summary cells are positioned besides each parent member and their child members appear next to them. The enumeration property layout needs to be set to “ej.PivotGrid.Layout.ExcelLikeLayout” in-order to view PivotGrid in excel-like layout.

TS

export class PivotGridComponent {
    public layout;
    constructor() {
        //..
        this.layout = ej.PivotGrid.Layout.ExcelLikeLayout; 
    }
}