DevExpress-Examples/winforms-pivot-grid-use-a-hidden-field-to-sort-visible-field-values

This example demonstrates how to sort the Sales Person field by the hidden Last Name data field.

Pivot Grid for WinForms - How to Use a Hidden Field to Sort the Visible Field Values

This example demonstrates how to sort the Sales Person field by the hidden Last Name data field.

Check the Enable custom sorting box to sort the Sales Person values by Last Name instead of the default alphabetical sort order.

The checked Enable custom sorting box enables the Sorting by Summary functionality for the Sales Person field. The Last Name field is placed in the Data Area to calculate a summary value that is used to sort the Sales Person field values.

This example uses the following API:

• PivotGridFieldBase.SortBySummaryInfo property
• PivotGridFieldSortBySummaryInfo.Field property
• PivotGridFieldBase.SummaryType property
• PivotGridFieldBase.Visible property
• PivotGridFieldBase.Area property

Files to Review

• Form1.cs (VB: Form1.vb)

Documentation

• Sorting
• Binding to Excel Data Source

Does this example address your development requirements/objectives?

(you will be redirected to DevExpress.com to submit your response)