New to Telerik UI for ASP.NET AJAXStart a free 30-day trial

Aggregates Position

RadPivotGrid offers several options for setting its aggregate position depending on the row table layout. These options could be set my using the RowTableLayout, AggregatesPosition and AggregatesLevel properties of the control. The aggregate position could be set to Rows or Column.

Below follow descriptions of the Aggregate positions based on the RowTableLayout and the and AggregatesLevel.

AggregatesPosition="Rows"

RowTableLayout="Tabular"

  • Below is an example with aggregates on level three:
ASPNET
<telerik:RadPivotGrid RenderMode="Lightweight" ID="RadPivotGrid1" runat="server" DataSourceID="SqlDataSource1" Skin="Metro" AggregatesPosition="Rows" RowTableLayout="Tabular" AggregatesLevel="3">

Pivot Grid-Rows Tabular 3 Level Here is the same layout with items on the first level collapsed: Pivot Grid-Rows Tabular 3 Level 1 Collapsed

  • Below is an example with aggregates on level two:
ASPNET
<telerik:RadPivotGrid RenderMode="Lightweight" ID="RadPivotGrid1" runat="server" DataSourceID="SqlDataSource1" Skin="Metro" AggregatesPosition="Rows" RowTableLayout="Tabular" AggregatesLevel="2">

Pivot Grid-Rows Tabular 2 Level Here is the same layout with some collapsed items: Pivot Grid-Rows Tabular 2 Level Collapsed

  • Below is an example with aggregates on level one:
ASPNET
<telerik:RadPivotGrid RenderMode="Lightweight" ID="RadPivotGrid1" runat="server" DataSourceID="SqlDataSource1" Skin="Metro" AggregatesPosition="Rows" RowTableLayout="Tabular" AggregatesLevel="1">

Pivot Grid-Rows Tabular 1 Level Here is the same layout with some collapsed items: Pivot Grid-Rows Tabular 1 Level Collapsed

  • Below is an example with aggregates on level zero:
ASPNET
<telerik:RadPivotGrid RenderMode="Lightweight" ID="RadPivotGrid1" runat="server" DataSourceID="SqlDataSource1" Skin="Metro" AggregatesPosition="Rows" RowTableLayout="Tabular" AggregatesLevel="0">

Pivot Grid-Rows Tabular 0 Level Here is the same layout with some collapsed items: Pivot Grid-Rows Tabular 0 Level Collapsed.jpg

RowTableLayout="Outline"

  • Below is an example with aggregates on level three:
ASPNET
<telerik:RadPivotGrid RenderMode="Lightweight" ID="RadPivotGrid1" runat="server" DataSourceID="SqlDataSource1" Skin="Metro" AggregatesPosition="Rows" RowTableLayout="Outline" AggregatesLevel="3">

Pivot Grid-Rows Outline 3 Level Here is the same layout with some collapsed items: Pivot Grid-Rows Outline 3 Level Collapsed

  • Below is an example with aggregates on level two:
ASPNET
<telerik:RadPivotGrid RenderMode="Lightweight" ID="RadPivotGrid1" runat="server" DataSourceID="SqlDataSource1" Skin="Metro" AggregatesPosition="Rows" RowTableLayout="Outline" AggregatesLevel="2">

Pivot Grid-Rows Outline 2 Level

  • Below is an example with aggregates on level one with collapsed items:
ASPNET
<telerik:RadPivotGrid RenderMode="Lightweight" ID="RadPivotGrid1" runat="server" DataSourceID="SqlDataSource1" Skin="Metro" AggregatesPosition="Rows" RowTableLayout="Outline" AggregatesLevel="1">

Pivot Grid-Rows Outline 1 Level Collapsed

  • Below is an example with aggregates on level zero with collapsed items:
ASPNET
<telerik:RadPivotGrid RenderMode="Lightweight" ID="RadPivotGrid1" runat="server" DataSourceID="SqlDataSource1" Skin="Metro" AggregatesPosition="Rows" RowTableLayout="Outline" AggregatesLevel="0">

Pivot Grid-Rows Outline 0 Level Collapsed

RowTableLayout="Compact"

  • Below is an example with aggregates on level three:
ASPNET
<telerik:RadPivotGrid RenderMode="Lightweight" ID="RadPivotGrid1" runat="server" DataSourceID="SqlDataSource1" Skin="Metro" AggregatesPosition="Rows" RowTableLayout="Compact" AggregatesLevel="3">

Pivot Grid-Rows Compact 3 Level Here is the same layout with items on the first level collapsed: Pivot Grid-Rows Compact 3 Level Collapsed

  • Below is an example with aggregates on level two:
ASPNET
<telerik:RadPivotGrid RenderMode="Lightweight" ID="RadPivotGrid1" runat="server" DataSourceID="SqlDataSource1" Skin="Metro" AggregatesPosition="Rows" RowTableLayout="Compact" AggregatesLevel="2">

Pivot Grid-Rows Compact 2 Level

  • Below is an example with aggregates on level one with some collapsed items:
ASPNET
<telerik:RadPivotGrid RenderMode="Lightweight" ID="RadPivotGrid1" runat="server" DataSourceID="SqlDataSource1" Skin="Metro" AggregatesPosition="Rows" RowTableLayout="Compact" AggregatesLevel="1">

Pivot Grid-Rows Compact 1 Level Collapsed

  • Below is an example with aggregates on level zero with some collapsed items:
ASPNET
<telerik:RadPivotGrid RenderMode="Lightweight" ID="RadPivotGrid1" runat="server" DataSourceID="SqlDataSource1" Skin="Metro" AggregatesPosition="Rows" RowTableLayout="Compact" AggregatesLevel="0">

Pivot Grid-Rows Compact 0 Level Collapsed

AggregatesPosition="Columns"

RowTableLayout="Tabular"

  • Below is an example with aggregates on level two:
ASPNET
<telerik:RadPivotGrid RenderMode="Lightweight" ID="RadPivotGrid1" runat="server" DataSourceID="SqlDataSource1" Skin="Metro" AggregatesPosition="Columns" RowTableLayout="Tabular" AggregatesLevel="2">

Pivot Grid-Columns Tabular 2 Level

  • Below is an example with aggregates on level one:
ASPNET
<telerik:RadPivotGrid RenderMode="Lightweight" ID="RadPivotGrid1" runat="server" DataSourceID="SqlDataSource1" Skin="Metro" AggregatesPosition="Columns" RowTableLayout="Tabular" AggregatesLevel="1">

Pivot Grid-Columns Tabular 1 Level Here is the same layout with some collapsed items: Pivot Grid-Columns Tabular 1 Level Collapsed

  • Below is an example with aggregates on level zero:
ASPNET
<telerik:RadPivotGrid RenderMode="Lightweight" ID="RadPivotGrid1" runat="server" DataSourceID="SqlDataSource1" Skin="Metro" AggregatesPosition="Rows" RowTableLayout="Tabular" AggregatesLevel="0">

Pivot Grid-Columns Tabular 0 Level

RowTableLayout="Outline"

  • Below is an example with aggregates on level two:
ASPNET
<telerik:RadPivotGrid RenderMode="Lightweight" ID="RadPivotGrid1" runat="server" DataSourceID="SqlDataSource1" Skin="Metro" AggregatesPosition="Columns" RowTableLayout="Outline" AggregatesLevel="2">

Pivot Grid-Columns Outline 2 Level

  • Below is an example with aggregates on level one :
ASPNET
<telerik:RadPivotGrid RenderMode="Lightweight" ID="RadPivotGrid1" runat="server" DataSourceID="SqlDataSource1" Skin="Metro" AggregatesPosition="Columns" RowTableLayout="Outline" AggregatesLevel="1">

Pivot Grid-Columns Outline 1 Level

  • Below is an example with aggregates on level zero:
ASPNET
<telerik:RadPivotGrid RenderMode="Lightweight" ID="RadPivotGrid1" runat="server" DataSourceID="SqlDataSource1" Skin="Metro" AggregatesPosition="Columns" RowTableLayout="Outline" AggregatesLevel="0">

Pivot Grid-Columns Outline 0 Level

RowTableLayout="Compact"

  • Below is an example with aggregates on level two:
ASPNET
<telerik:RadPivotGrid RenderMode="Lightweight" ID="RadPivotGrid1" runat="server" DataSourceID="SqlDataSource1" Skin="Metro" AggregatesPosition="Columns" RowTableLayout="Compact" AggregatesLevel="2">

Pivot Grid-Columns Compact 2 Level Here is the same layout with three column fields and some collapsed items: Pivot Grid-Columns Compact 2 Level Collapsed

  • Below is an example with aggregates on level one with three column fields and some collapsed items:
ASPNET
<telerik:RadPivotGrid RenderMode="Lightweight" ID="RadPivotGrid1" runat="server" DataSourceID="SqlDataSource1" Skin="Metro" AggregatesPosition="Columns" RowTableLayout="Compact" AggregatesLevel="1">

Pivot Grid-Columns Compact 1 Level Collapsed

  • Below is an example with aggregates on level zero with three column fields and some collapsed items:
ASPNET
<telerik:RadPivotGrid RenderMode="Lightweight" ID="RadPivotGrid1" runat="server" DataSourceID="SqlDataSource1" Skin="Metro" AggregatesPosition="Columns" RowTableLayout="Compact" AggregatesLevel="0">

Pivot Grid-Columns Compact 0 Level Collapsed