Chat Now
BuySupport CenterDocumentationBlogsTrainingDemosFree TrialLog In
ASP.NET Web Forms Controls
V 20.2
20.2
20.1
19.2
19.1
18.2
18.1
17.2
All docs
Docs > Components > Pivot Grid > Examples > Data Shaping
All docs
V20.2

General Information

.NET Subscription

Overview

Common Tools

Project Converter
Assembly Deployment Tool
Localization Service

Quality Assurance and Productivity

CodeRush
CodeRush Classic
TestCafe Studio
Logify

Desktop

Controls

WinForms
WPF
VCL
UWP (Windows 10)

Tools

WinForms Skin Editor
WPF Theme Designer
WPF Theme Editor (Legacy)
Coded UI Test Extension

Frameworks and Libraries

eXpressApp Framework (XAF)
eXpress Persistent Objects (XPO)
XPO Profiler
Core Libraries

Web

Controls and Extensions

ASP.NET Web Forms Controls
ASP.NET MVC Extensions
ASP.NET Core Controls
ASP.NET Bootstrap Controls
DevExtreme
DevExtreme ASP.NET MVC Controls
Blazor Components

Tools

ASP.NET Theme Builder
ASP.NET Theme Deployer

Maintenance Mode

ASP.NET Core Bootstrap Controls

Mobile

UI Controls for Xamarin.Forms
Charts for iOS / Xamarin.iOS
Charts for Android / Xamarin.Android

Enterprise and Analytic Tools

Reporting
Report and Dashboard Server
Dashboard
Office File API

End-User Documentation

Interface Elements for Desktop
Interface Elements for Web
Dashboard for Desktop
Dashboard for Web
20.2
20.1
19.2
19.1
18.2
18.1
17.2
Full-text search
ASP.NET Web Forms Controls
Prerequisites
What's Installed
Get Started
Common Concepts
Components
Card View
Chart Control
Data and Image Navigation
Data Editors
Diagram
Docking and Popups
File Management
Gantt
Gauges
Grid View
HTML Editor
Multi-Use Site Controls
Pivot Grid
Getting Started
Fundamentals
Binding to Data
Data Shaping
Data Analysis
Data Formatting
Layout
Appearance
Export
Design-Time Features
UI Elements
Examples
Binding to Data
Data Shaping
How to: Add Custom Totals
How to: Calculate Multiple Custom Totals with Custom Summary Type
How to: Calculate Running Totals
How to: Apply a Filter
How to: Implement the Group Filter
How to: Change the Prefilter's Criteria in Code
How to: Display Underlying Records
How to: Group Date-Time Values
How to: Implement Custom Group Intervals
How to: Implement Custom Summary
How to: Sort Data by a Data Field
How to: Sort Data by Individual Columns (Rows)
How to: Sort Data by Individual Columns (Rows) in OLAP Mode
How to: Sort Data in Server Mode Using Custom Sorting Algorithm
How to: Sort Data by OLAP Member Properties
How to: Prevent End-Users From Changing Filter Conditions
How to: Replace Default Filter Items with Custom Ones
How to: Add and Remove Items From Filter Drop-Down Lists
How to: Sort Filter Drop-Down Items in a Custom Manner
How to: Locate a Column (Row) Header By Its Column's (Row's) Summary Values
Data Analysis
Data Formatting
Layout
Appearance
Data Export
Popup Menu
Miscellaneous
End-User Capabilities
Member Tables
Reporting
Rich Text Editor
Scheduler
Site Navigation and Layout
Spell Checker
Spreadsheet
Tree List
Vertical Grid
Query Builder
Redistribution and Deployment
Troubleshooting
Get More Help
.NET Framework API Reference
Client API Reference
Download CHM

General Information

.NET Subscription

Overview

Common Tools

Project Converter
Assembly Deployment Tool
Localization Service

Quality Assurance and Productivity

CodeRush
CodeRush Classic
TestCafe Studio
Logify

Desktop

Controls

WinForms
WPF
VCL
UWP (Windows 10)

Tools

WinForms Skin Editor
WPF Theme Designer
WPF Theme Editor (Legacy)
Coded UI Test Extension

Frameworks and Libraries

eXpressApp Framework (XAF)
eXpress Persistent Objects (XPO)
XPO Profiler
Core Libraries

Web

Controls and Extensions

ASP.NET Web Forms Controls
ASP.NET MVC Extensions
ASP.NET Core Controls
ASP.NET Bootstrap Controls
DevExtreme
DevExtreme ASP.NET MVC Controls
Blazor Components

Tools

ASP.NET Theme Builder
ASP.NET Theme Deployer

Maintenance Mode

ASP.NET Core Bootstrap Controls

Mobile

UI Controls for Xamarin.Forms
Charts for iOS / Xamarin.iOS
Charts for Android / Xamarin.Android

Enterprise and Analytic Tools

Reporting
Report and Dashboard Server
Dashboard
Office File API

End-User Documentation

Interface Elements for Desktop
Interface Elements for Web
Dashboard for Desktop
Dashboard for Web

Data Shaping

  • Dec 17, 2020

This section contains the following examples:

  • How to: Add Custom Totals
  • How to: Calculate Multiple Custom Totals with Custom Summary Type
  • How to: Calculate Running Totals
  • How to: Apply a Filter
  • How to: Implement the Group Filter
  • How to: Change the Prefilter's filter criteria in code
  • How to: Display Underlying Records
  • How to: Group Date-Time Values
  • How to: Implement Custom Group Intervals
  • How to: Implement Custom Summary
  • How to: Sort Data by a Data Field
  • How to: Sort Data by Individual Columns (Rows)
  • How to: Sort Data by Individual Columns (Rows) in OLAP Mode
  • How to: Sort Data in Server Mode Using Custom Sorting Algorithm
  • How to: Sort Data by OLAP Member Properties
  • How to: Prevent End-Users From Changing Filter Conditions
  • How to: Replace Default Filter Items with Custom Ones
  • How to: Add and Remove Items From Filter Drop-Down Lists
  • How to: Sort Filter Drop-Down Items in a Custom Manner
  • How to: Locate a Column (Row) Header By Its Column's (Row's) Summary Values
Feedback
Was this page helpful?
Thanks for your feedback!
Any other suggestions? Tell us here.
Use of this site constitutes acceptance of our Website Terms of Use and Privacy PolicyDo Not Sell My Personal Information
Copyright © 1998-2021 Developer Express Inc. All trademarks or registered trademarks are property of their respective owners