[Expand]General Information
[Collapse]WinForms Controls
  .NET Core Support
 [Expand]What's Installed
 [Expand]Build an Application
 [Collapse]Controls and Libraries
  [Expand]Forms and User Controls
  [Expand]Messages, Notifications, and Dialogs
  [Expand]Editors and Simple Controls
  [Expand]Ribbon, Bars and Menu
  [Expand]Application UI Manager
  [Expand]Docking Library
  [Expand]Data Grid
  [Expand]Vertical Grid
  [Expand]Property Grid
  [Collapse]Pivot Grid
   [Expand]Getting Started
   [Expand]Binding to Data
   [Collapse]Data Shaping
     Data Formatting
   [Expand]Data Analysis
   [Expand]Focus and Navigation
   [Expand]Printing and Exporting
   [Expand]Design-Time Features
   [Expand]UI Elements
   [Expand]End-User Capabilities
   [Expand]Member Tables
  [Expand]Tree List
  [Expand]Gantt Control
  [Expand]Chart Control
  [Expand]Map Control
  [Expand]Rich Text Editor
  [Expand]Spell Checker
  [Expand]Form Layout Managers
  [Expand]Navigation Controls
  [Expand]PDF Viewer
  [Expand]TreeMap Control
  [Expand]Sunburst Control
 [Expand]Common Features
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Controls and MVC Extensions
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Office File API
[Expand]Report and Dashboard Server
[Expand]eXpressApp Framework
[Expand]eXpress Persistent Objects
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation
View this topic on docs.devexpress.com (Learn more)

Data Shaping

Topics in the following sections describe data-related features provided by the Pivot Grid. These include data filtering, value formatting, sorting and grouping data, using summaries, etc.

The following sections and topics are available.

  • Summarization

    Topics in this section describe how the Pivot Grid Control processes underlying data and displays the results of the calculations.

  • Grouping

    This topic describes how to group field values into categories (ranges) automatically.

  • Sorting

    Topics in this section provide information on how Pivot Grid Control data can be sorted.

  • Filtering

    Topics in this section describe Pivot Grid Control filtering capabilities.

  • Editing

    Topics in this section describe how data cell values displayed in the Pivot Grid Control can be edited by end-users to perform a 'what-if' analysis.

  • Data Formatting

    This topic describes how to format the display text of its data cells, field values, summaries, totals and grand totals before they are displayed on screen.

Is this topic helpful?​​​​​​​