Properties Menu - Column Total

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.

column total1

Below is the screenshot where the Column totals is enabled and ‘Total’ column is displaying in the chart calculationg the metrics in the chart.

column total1

Below is the screenshot where the grouping is applied on Category attribute and ‘Total’ column is calculating across the metrics ‘Cost’ and ‘Profit’.

column total1

Column Totals with Pivot

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.

column total1

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.

column total1