From the 4.5 version of Vitara charts, column totals feature is implemented in the Grid chart. By default, the column total is not shown. We have to enable the Column Totals in the ‘SubTotals’ property in the property editor.
The only default aggregation for Column Totals is “Sum” of the metrics in the chart.
Below is the screenshot where the column totals are in enabled state.
Below is the screenshot where the Column totals is enabled and ‘Total’ column is displaying in the chart calculationg the metrics in the chart.
Below is the screenshot where the grouping is applied on Category attribute and ‘Total’ column is calculating across the metrics ‘Cost’ and ‘Profit’.
Pivot any attribute in the chart, and enable the Column Totals in the Sub totals property. Now you can see the ‘Total’ column calculated across the metrics.
Below is the screenshot where Category attribute is pivoted and Total is calculated across the Cost and Profit metrics.
When ‘Move to rows’ applied on the metrics in the chart, the Totals column can be seen if and only the ‘Metrics’ column along with an attribute are in the pivot zone. The ‘Metrics’ column should be in the first position of the pivot zone.
Below is the screenshot shown where Total column is shown when ‘Metrics’ column and Year attribute are pivoted.