Cross Table has additional configuration in Advance Sort, to add sorting
condition based on the Column Grand Total.
To understand the configurations, follow the below steps:
1. Plot cross table,
ex. Below configuration

The plotted chart shows data as below:
2. Navigate to
Advance Sort options. The additional option is displayed with name- Add Column
Grand Total.

3. On click of -Add
Column Grand Total, the sorting level is added.
4. On click of Select
Column dropdown, the column/s configured in the Value configuration are
displayed. Select any column.
5. Set the sorting
level as Descending or Ascending.
6. Click Apply.
7. Observe the chart
data. Data in the Column Grand Total Column (Births-Sum) is displayed sorted in
Descending order considering entire row values.
Notes:
|
o The
sorting levels can be added on any number of columns in the value
configuration with different sorting.
o The
sorting on -Column Grand total Column can be combined with the sorting on
other dimension columns in the configuration.
|