Example of Custom Sorting in ASP.NET MVC Pivot Table Control
This sample demonstrates ordering used-defined member(s), aka header name(s), of specific field in row and column axes in ascending or descending order.
DEMO
SOURCE
|
|
|
|
Field:
|
|
|
Headers:
|
|
|
Order:
|
|
|
|
|
In this sample, any field from the Field dropdown list and its member(s), aka header name(s), from the Headers dropdown list can be ordered ascending or descending.
It is possible to achieve this by setting the enableSorting property to true,
as well as the field name, sort order, and member(s) (which can be in any order) inside the pivot table's sortSettings property.
The dataSourceSettings includes enableSorting and sortSettings properties.