Support Advance Sort with Grand Total Column in Cross Table

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.

 


    • Related Articles

    • Grand Total

      The Grand Total formatting option is available in the Cross Table widget. By default, the Grand Total formatting options are not visible. Turn the toggle button ON () to use the Grand Total formatting options. The table given below describes ...
    • Total

      The Total formatting option is available in the Table chart. The table given below describes different fields present on Total formatting. Field Description Remark Label It allows you to select the label you want to assign for the Total column. — ...
    • Total And Sub-Totals

      No table of figures entries was found.h1. Formatting a Table You can format the tables that appear in various charts. Tables can be plotted standalone like Table and Cross Table, or they accompany other charts (like Sparkline Chart in which they ...
    • Support Vector Machine

      Support Vector Machine is located under Textual Analysis ( ) in Classification, in the left task pane. Use the drag-and-drop method to use the algorithm in the canvas. Click the algorithm to view and select different properties for analysis. Refer to ...
    • Support Vector Machine in Regression

      The location of the Support Vector Machine is under Machine Learning in Regression on the feature studio. Alternatively, use the search bar to find Support Vector Machine (SVM) algorithm. Use the drag-and-drop method or double-click to use the ...