Apply a New Sort

1.  Right-click the object in the grid and select Sort then either Ascending or Descending. If you want to sort a Grand Total, right-click the caption of the measure item in the Grand Total row or column.

OR

1.  Double-click the object in view explorer to open its Properties window.

2.  Select Ascending or Descending from the Sort drop-down list.

Note: Use the first option if you are sorting a measure item and there are levels on the same axis as measure items. Also use the first option if you are sorting a Grand Total measure it. See Why is a Sort Property Disabled?.