Skip to main content
BuyLog In
WinForms Controls
Search in…
Docs > Controls and Libraries > Pivot Grid > Data Shaping
All docs
V24.2
WinForms Controls
.NET Support and Migration
Prerequisites
What's New
What's Installed
Build an Application
Redistribution and Deployment
Controls and Libraries
Forms and User Controls
Messages, Notifications, and Dialogs
Editors and Simple Controls
Ribbon, Bars and Menu
Application UI Manager
Docking Library
Data Grid
Vertical Grid
Property Grid
Pivot Grid
Getting Started
Fundamentals
Binding to Data
Asynchronous Mode
Data Shaping
Summarization
Grouping
Sorting
Filtering
Pinned (Fixed) Columns
Editing
Data Formatting
Data Analysis
Layout
Focus and Navigation
Printing and Exporting
Appearance
Design-Time Features
Miscellaneous
UI Elements
End-User Capabilities
Examples
Tree List
Gantt Control
Chart Control
Diagrams
Gauges
Map Control
Scheduler
Spreadsheet
Rich Text Editor
Spell Checker
Form Layout Managers
Navigation Controls
Printing-Exporting
PDF Viewer
Reporting
Office File API
Snap
TreeMap Control
Sunburst Control
Sankey Diagram Control
Heatmap Control
Icon and Image Library
AI-powered Extensions
Common Features
Security Considerations
Data Access Security
Hybrid & Enterprise Development
UI Templates
Desktop & Web App UI Framework (Powered by EF Core)
Get More Help
API Reference
Download CHM

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.

  • Pinned (Fixed) Columns

    The topic describes how to pin columns in the Pivot Grid Control.

  • 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.