Sorting in Windows Forms Pivot Grid

24 Aug 20214 minutes to read

Pivot grid provides support for sorting which enables users to quickly visualize, organize and understand the data in a better way. Sorting feature also helps to find the data that you want and make more effective decisions ultimately.

The sorting operation can be performed in the pivot grid control using any of the following ways:

Using custom comparer programmatically

By default, the pivot grid control populates the data in the ascending order. This sorting order can be changed by using the Comparer property of pivot item.

public partial class Form1 : Form
    public Form1()
        this.pivotGridControl1.PivotRows.Add(new PivotItem
            FieldMappingName = "Product",
            TotalHeader = "Total",
            Comparer = new ReverseOrderComparer()

public class ReverseOrderComparer : IComparer
   public int Compare(object x, object y)
      if (x == null && y == null)
         return 0;
      else if (y == null)
         return 1;
      else if (x == null)
         return -1;
         return -x.ToString().CompareTo(y.ToString());
Partial Public Class Form1
    Inherits Form
    Public Sub New()
        Me.pivotGridControl1.PivotRows.Add(New PivotItem With
            .FieldMappingName = "Product",
            .TotalHeader = "Total",
            .Comparer = New ReverseOrderComparer()
    End Sub
End Class

Public Class ReverseOrderComparer
    Implements IComparer
    Public Function Compare(ByVal x As Object, ByVal y As Object) As Integer
        If x Is Nothing AndAlso y Is Nothing Then
            Return 0
        ElseIf y Is Nothing Then
            Return 1
        ElseIf x Is Nothing Then
            Return -1
            Return -x.ToString().CompareTo(y.ToString())
        End If
    End Function
End Class


Using grouping bar

The sorting operation can also be performed by clicking on the header item of required pivot field present in row and column header areas of grouping bar.

By default, the pivot field values are sorted in the ascending order. On clicking the same header item once again will reverse the sorting direction. The sort indicator present at the right corner of the header item denotes the type of sorting applied to the pivot field such as ascending order or descending order.