The Sort group includes the commands for sorting data in the pivot grid table. Ascending sorting and Descending sorting are available. The user can additionally configure the sorting parameters. The sorting can be applied to a row area, column area, or data area in the pivot grid table.
Sort Options allow for sorting rows (Rows Sort) or columns (Columns Sort) in the pivot grid table:
  • Based on the main properties of a dimension member (KEY0, Caption) - Sort By Property
  • Based on the current data context - Sort By Row (Columns) Context

Sorting settings

In this example, [Date].[Calendar] hierarchy columns were not sorted in the client workstation (they are displayed in the order as arranged as a result of an MDX query). Hierarchy [Sales Territory].[ Sales Territory] was arranged in the ascending order, and hierarchy [Measures] was arranged in the descending order. Rows were arranged in the ascending order.

Result of the sorting settings

The sorting is done in the client workstation.

Last edited Mar 18, 2011 at 8:17 AM by Leschenok, version 5