Grid layout

Normal layout

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

  • html
  • <ej:PivotGrid ID="PivotGrid1" runat="server" Url="/PivotGridService.svc" Layout="Normal"></ej:PivotGrid>

    Normal layout in ASP NET pivot grid control

    No summaries layout

    IMPORTANT

    This feature is applicable only for the OLAP data source.

    A layout in summary cells, which are completely hidden and the child members appear next to their parent member. The Layout enumeration property should be set to “NoSummaries” to view the pivot grid without summaries.

  • html
  • <ej:PivotGrid ID="PivotGrid1" runat="server" Url="/PivotGridService.svc" Layout="NoSummaries"></ej:PivotGrid>

    No summaries layout in ASP NET pivot grid control

    Excel-like layout

    A layout in summary cells, which are positioned besides each parent member and their child members appear next to them. The Layout enumeration property should be set to “ExcelLikeLayout” to view the pivot grid in Microsoft Excel.

  • html
  • <ej:PivotGrid ID="PivotGrid1" runat="server" Url="/PivotGridService.svc" Layout="ExcelLikeLayout"></ej:PivotGrid>

    Excel like layout in ASP NET pivot grid control

    Top summary Layout

    IMPORTANT

    This feature is applicable only for the OLAP data source at server mode.

    A layout in summary cells, which are positioned at the top of each parent member and their child members appear next to them. The Layout enumeration property should be set to “NormalTopSummary” to view the pivot grid in the top summaries layout.

  • html
  • <ej:PivotGrid ID="PivotGrid1" runat="server" Url="/PivotGridService.svc" Layout="NormalTopSummary"></ej:PivotGrid>

    Top summary layout in ASP NET pivot grid control