Sorting

Sorting sorts the elements of a list. Sorting criteria affect the number of elements transferred from the OLAP Server database.

Sorting-criteria settings

You can sort elements in a list by these criteria:


Criteria	Description
Caption	Sort the elements by their captions.
Unique name	Sort the elements by their unique names.
Attribute	Sort elements by their attributes.
Value	Sort the elements by values. You may define the slice of data to which the sort applies. SeeDefining the Data Area.
Custom MDX	You can define sorting with an MDX statement.

Specify whether the values of the list are sorted in ascending or descending order.

The elements are sorted by their values. If you sort by Value, you must define the cut-off type, the cut-off value and the Data Area.

The cut of types are:


Cut-off type	Cut-off value	Example
Top Count/Bottom Count	Specify, how many elements with top or bottom values are displayed.	Show the top 5 products.
Top Sum/Bottom Sum	Specify the sum of the elements that is displayed.	Show products, whose total turnover is at least 50.000.
Top/bottom sum, equivalent to x% of the total sum	Enter a percentage.	Show the products that make up 30% of the total turnover.

If you select the cut-off type None, all the list elements are sorted in ascending or descending order.