Support Advance Sort with Grand Total Column in Cross Table
Refer Advance
Sort for configuring sorting on the widgets.
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. |