Grid Layout

11 Feb 20191 minute 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 “PivotGridLayout.Normal” in-order to view PivotGrid in normal layout.

CSHTML

@Html.EJ().Pivot().PivotGrid("PivotGrid1").Layout(PivotGridLayout.Normal).Url(Url.Content("/OLAPService"))

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 “PivotGridLayout.NoSummaries” in-order to view PivotGrid without summaries.

CSHTML

@Html.EJ().Pivot().PivotGrid("PivotGrid1").Layout(PivotGridLayout.NoSummaries).Url(Url.Content("/OLAPService"))

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 “PivotGridLayout.ExcelLikeLayout” in-order to view PivotGrid in excel-like layout.

CSHTML

@Html.EJ().Pivot().PivotGrid("PivotGrid1").Layout(PivotGridLayout.ExcelLikeLayout).Url(Url.Content("/OLAPService"))

Top Summary Layout

IMPORTANT

This feature is applicable only for OLAP datasource only at Server Mode.

A layout in which summary cells are positioned at the top of each parent member and their child members appear next to them. The enumeration property Layout needs to be set to “PivotGridLayout.NormalTopSummary” in-order to view PivotGrid in top summaries layout.

CSHTML

@Html.EJ().Pivot().PivotGrid("PivotGrid1").Layout(PivotGridLayout.NormalTopSummary).Url(Url.Content("~/OLAPService"))