With the xamPivotGrid control, you have several options that you can employ to narrow down the scope of the data in the grid. You can either do it from code or you can use the UI filter menus.
Sorting in the xamPivotGrid control can be configured on two levels – grid wide and column wide. Sorting is enabled for all columns by default. Each header cell has a sorting indicator with three states: Ascending, Descending, and Not Sorted. The end user can click on it to trigger sorting.
The xamPivotGrid provides the capability for the user to sort the order in which the columns and rows appear. This topic explains this functionality of the XamPivotGrid.