Cross Table Properties – Sorting

Tip: Sorting is easily done by clicking directly on a column title or row title in the cross table visualization.

When you are sorting a cross table, you always work on the last node of a hierarchy. For example, if the cross table shows sales figures for different types of fruits and vegetables, as in the example under What is a Cross Table?, and you click on the Apples leaf node, only the cell values within the Fruit >> Apples hierarchy will affect the sorting. You cannot sort on the entire Fruit category while subcategories are being displayed.

Option	Description
Sort rows by	Select the cross table column title by which you wish to sort.
Ascending	Sorts the cross table by the selected column title in ascending order.
Descending	Sorts the cross table by the selected column title in descending order.
Show only the first number of rows	Select this check box if you want to display a limited number of rows per category in the cross table. If you select ascending sort order, the rows with the bottom values will be shown. If you select descending sort order, the rows with the top values will be shown.
Indicate hidden rows	Select this check box if you want to get an indication that some rows in the cross table are not displayed when the check box Show only the first number of rows has been selected. A row with three dots in each cell will be added to indicate this.
Sort columns by	Select the row title you wish to sort the columns by in the cross table.
Ascending	Sorts the cross table by the selected row in ascending order.
Descending	Sorts the cross table by the selected row in descending order.
Show only the first number of columns	Select this check box if you want to display a limited number of columns per category in the cross table. If you select ascending sort order, the columns with the bottom values will be shown. If you select descending sort order, the columns with the top values will be shown.
Indicate hidden columns	Select this check box if you want to get an indication that some columns in the cross table are not displayed when the check box Show only the first number of columns has been selected. A column with three dots in each cell will be added to indicate this.