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. |
See also: