Sorting

Let us sort the table obtained earlier in the decreasing order of the “Order Count” measure.

For this, click in the right corner of the table next to an icon:

The column with the “Order Count” measure is sorted in a descending order:

Having clicked again, we get the opposite result (an increase of the “Order Count” measure).

To sort the hierarchy alphabetically, you need to open the context menu:

By selecting the “Sort Descending” method, we get a table with category names sorted in a descending order:

If necessary, you can disable sorting:

OLAP Sorting specific (in OLAP mode, you can use the following options to specify the sort order for attribute members):

• (Value) – sorting is performed by member values;
• (Display Text) – sorting is performed by captions associated with members;
• (Key) – sorting is performed by member keys;
• (ID) – sorting is performed by member