New to Telerik UI for ASP.NET AJAX? Download free 30-day trial

Fields Overview

Pivot Grid Fields represent data source fields and provide specific data to RadPivotGrid. The Fields headers are used for presenting the different fields that can be moved between control areas using drag-and-drop.

Fields:

To presents specific data in the RadPivotGrid, fields should be created and placed in the appropriated areas. Pivot Grid-Header Fields

Here are the available fields in RadPivotGrid:

  • DataFields - The PivotGrid calculates summaries against these fields. Visually they can be placed into the Data Header Area. Pivot Grid-Data-Cell-Area

  • ColumnFields - The PivotGrid represents row headers from these fields. Visually they can be placed into the Column Header Area. The ColumnFields control the PivotGrid Columns which can be nested Pivot Grid-Column

  • RowFields - The PivotGrid represents column header from these fields. Visually they can be placed into the Row Header Area. Pivot Grid-Rows

  • Drag and Drop Fileds- different fields can be moved between control areas using drag-and-drop.

All these zones can be hidden and only the data cells with their corresponding column header cells and row header cells could be shown.

In this article