Canvas now enables you to use specific features like displaying the grand total, average, count, etc, for a column on the whole using Select Group Header attribute in Sigma.
For instance, the simple report with grand and sub-totals is shown in the following screenshots:
- Sub-totals:
- Grand Total:
In order to generate the simple report as shown above, perform the following additional steps in Sigma:
- Click a column name from the selected column(s) to choose the group header.
A window appears on the right-hand side of the page as shown below:
- Click Select Group Header drop-down and select Sum as the group header.
- Click Group By drop-down to select the columns that needs to be grouped and those grouped sections will be provided with sub-totals for each.
Here, Reference Number column is selected in the Group By drop-down list.
