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.

Sorting

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

Cut off type and cut off value

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.

SeeDefining the Data Area.

Cut off

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.