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:

<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:

Below is an example with aggregates on level two:

<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:

Below is an example with aggregates on level one:

<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:

Below is an example with aggregates on level zero:

<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:

RowTableLayout="Outline"

Below is an example with aggregates on level three:

<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:

Below is an example with aggregates on level two:

<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:

<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:

<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:

<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:

Below is an example with aggregates on level two:

<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:

<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:

<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