Sort a dimension

To sort a dimension, you need to select what fact you will use to sort and the sorting order.

If you don't select a particular fact, the dimension is sorted in alphabetical order of the dimension name.

Select the AsC/Desc order

The sort by dimension icon toggles between sorting the dimension in ascending and descending order.  

For example below, the Customer dimension is sorted in ascending order, the Item Number dimension in ascending order.

 

Select a fact

You can also sort the dimension based on one of the facts in the view.

Right Hand Mouse button(RHMB)  on the fact name and then select which dimension you want to sort by.

To sort Customer Number by the Credit Limit, add the Credit Limit to the view, RHMB on the Credit Limit fact name and select Sort Customer Number by this dimension.

The "Sort by this column" is now selected.

You can see the Sort Icon next to the fact name in the view

 

See also Working with Info-Explorer - Home Tab