• Material 3
  • Material 3 Dark
  • Fluent
  • Fluent Dark
  • Bootstrap v5
  • Bootstrap v5 Dark
  • Tailwind CSS
  • Tailwind CSS Dark
  • Material
  • Bootstrap v4
  • High Contrast
Mode Selection
Theme Selection
*Translated by Google Translator.
Essential Studio
All Controls

Example of Value Sorting in ASP.NET Core Pivot Table Control

This sample demonstrates ordering of values in ascending or descending order. Here, the FY 2015 -> In Stock column header text is ordered by defining sort-related settings in code behind.


You can sort column values by clicking the column header. Clicking the same header once again will reverse the sorting direction. It can be enabled by setting the enableValueSorting as true.

Value sort-related settings can be defined in code behind, too. To do so, headers of the column to be sorted are given in the headerText property under valueSortSettings, separated by a delimiter string. The purpose of providing complete header text here is to indicate exactly which value column needs to be sorted. The string which is used to separate the headers is given in the property headerDelimiters. The sorting direction is performed by the sortOrder property.