Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

...

...

...

...

...

...

...

...

...

...

...

...

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:

Image Removed Image Added

  • Grand Total:

Image RemovedImage Added
In order to generate the simple report as shown above, perform the following additional steps in Sigma: 

  1. 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:

...


  1. Image Added

  2. Click Select Group Header drop-down and select Sum as the group header.

...


  1. Image Added

  2. 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.


Image RemovedImage Added