Log In
Home
Support
Demos
Documentation
Blogs
Training
Webinars
[Expand]General Information
[Expand]WinForms Controls
[Collapse]ASP.NET Controls and MVC Extensions
 [Expand]Prerequisites
 [Expand]What's Installed
 [Expand]Common Concepts
 [Collapse]ASP.NET WebForms Controls
  [Expand]Reporting
  [Expand]Chart Control
  [Expand]Grid View
  [Expand]Card View
  [Expand]Vertical Grid
  [Expand]Spreadsheet
  [Expand]Rich Text Editor
  [Expand]Image and Data Browsing
  [Expand]Docking and Popups
  [Expand]Site Navigation and Layout
  [Expand]File Management
  [Expand]Multi-Use Site Controls
  [Expand]Scheduler
  [Expand]HTML Editor
  [Collapse]Pivot Grid
   [Expand]Getting Started
   [Expand]Fundamentals
   [Expand]Binding to Data
   [Collapse]Data Shaping
    [Expand]Aggregation
     Grouping
    [Collapse]Sorting
      Data Sorting
      Display Top N Values
      Sorting by Summary
    [Expand]Filtering
   [Expand]Data Analysis
   [Expand]Data Formatting
   [Expand]Layout
   [Expand]Appearance
   [Expand]Data Export
   [Expand]Design-Time Features
   [Expand]UI Elements
   [Expand]Examples
   [Expand]End-User Capabilities
   [Expand]Member Tables
  [Expand]Tree List
  [Expand]Gauges
  [Expand]Data Editors
  [Expand]Spell Checker
  [Expand]Query Builder
 [Expand]ASP.NET MVC Extensions
 [Expand]Localization
 [Expand]Redistribution and Deployment
  Get More Help
 [Expand]API Reference
[Expand]ASP.NET Bootstrap Controls
[Expand]ASP.NET Core Bootstrap Controls
[Expand]WPF Controls
[Expand]Xamarin Controls
[Expand]Windows 10 App Controls
[Expand]Document Server
[Expand]Reporting
[Expand]Report Server
[Expand]Dashboard
[Expand]eXpressApp Framework
[Expand]CodeRush
[Expand]CodeRush Classic
[Expand]Cross-Platform Core Libraries
[Expand]Tools and Utilities
 End-User Documentation

Sorting by Summary

Sorting by Summary allows you to sort the current column or row field's values by corresponding summary values.

The following image illustrates the Pivot Grid Control with Product field values sorted by the USA | Margaret Peacock | Quantity column:

To see this feature in action, refer to the following online demo: Sort by Summary.

This topic consists of the following sections:

Expanded End-User Sorting by Summary

End-users can sort by summary through the context menu by right-clicking an innermost column or row header.

The image in the row's/column's header indicates if the field values are sorted by this row/column.

Sorting by Summary is available for all fields displayed within the Column Header Area or Row Header Area. There are two ways you can disable this functionality for end-users:

Property

Description

Note

PivotGridOptionsCustomization.AllowSortBySummary Gets or sets whether end-users can sort row field values by column values, and column field values by row values. This property affects all fields.
PivotGridFieldOptions.AllowSortBySummary Gets or sets whether end-users can sort the current row/column field values by other column/row summary values. This property affects individual fields.

Note that in this instance, individual fields' settings take priority over ASPxPivotGrid settings.

Expanded Sorting by Summary in Code

Use the field's PivotGridFieldBase.SortBySummaryInfo property to get access to the settings that are used to sort the values of the current column field or row field by corresponding summary values.

You need to specify a data field whose summary values should define the sort order to sort data by summaries. Do one of the following:

  • Assign the data field to the PivotGridFieldSortBySummaryInfo.Field property.

    This allows you to sort data by the currently displayed summary values.

  • Assign the data field name to the PivotGridFieldSortBySummaryInfo.FieldName property.

    In this instance, data is sorted by summary values calculated with the function whose type is specified by the PivotGridFieldSortBySummaryInfo.SummaryType property, regardless of which summary values are currently displayed.

After you specified a data field, ASPxPivotGrid sorts field values by a Grand Total column/row that corresponds to this data field.

The image below shows the Pivot Grid sorted by the Extended Price's Grand Total values:

To sort field values by any other column/row or their totals, identify this field by adding sort conditions using the PivotGridFieldSortBySummaryInfo.Conditions property. Each condition is a PivotGridFieldSortCondition object that identifies a field value so that the whole collection identifies a column/row.

Create two sort conditions to sort field values by the Qtr 2 Total column total.

The image below demonstrates the corresponding result:

Create the additional condition to sort data by the specified column/row:

Three sort conditions identify the highlighted column on the image below:

You can sort data by a custom total column/row by specifying its type using the PivotGridFieldSortBySummaryInfo.CustomTotalSummaryType property.

Use the PivotGridFieldBase.SortOrder property to specify whether to sort values in ascending or descending order.

Expanded Sorting by Summary in OLAP

In OLAP mode, create sort conditions using a PivotGridFieldSortCondition.PivotGridFieldSortCondition constructor overload that takes an OLAP member's unique name as a parameter.

Use the ASPxPivotGrid.GetFieldValueOLAPMember method to obtain an OLAP member for a field value. This method returns an object that implements the IOLAPMember interface. To access the OLAP member's unique name, use its IOLAPMember.UniqueName property.

Expanded Limitations

The following Pivot Grid features are not supported or ignored when you sort data by summary:

Expanded Examples

How would you rate this topic?​​​​​​​