Grand totals and subtotals

A grand total is a value that is composed by adding together other total amounts (subtotals) of the row/column.

When creating a report, you can change the default way grand totals and subtotals are displayed on the grid. The available options are:

• Show and hide grand totals for the entire report
• Show and hide subtotals for the entire report
• Show grand totals only for the rows or columns
• Show subtotals only for the rows or columns

To show or hide grand totals and subtotals

Via UI

1. Go to the Options () tab on the Toolbar.
2. Choose how to display grand totals and subtotals.
3. Apply the changes.

Programmatically

Configure totals through the grid.showTotals property of the Options Object:

report = {
  options: {
    grid: {
      showTotals: "off"
    }
  }
};

Configure grand totals through the grid.showGrandTotals property of the Options Object:

report = {
  options: {
    grid: {
      showGrandTotals: "rows"
    }
  }
};

It is also possible to set grid.showTotals and grid.showGrandTotals options for all reports.

Example

Hide grand totals from the entire report:

Hide grand totals from the rows:

The layout of subtotals is changed similarly.