Page Comparison

Sigma 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 application.

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: 

1. Click a column name from the selected column(s) to choose the group header. For example, Available Balance is selected here.
   
   A window appears on the right-hand side of the page as shown below:
   Image Removed
   Image Added
2. Click Select Group Header drop-down and select Sum as the group header.
   Image Removed
   Image Added
3. 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

   Info
   You can enable page reset and page break options for group by columns by selecting Page Reset (Image RemovedImage Added) and Page Break (Image RemovedImage Added) icons respectively.

   
   

4. Perform the other actions and follow any of the steps to generate the report:
   
   
   • To execute the report, click Run.
     or
   • To save the report, click Save.
     or

   • To save and execute (generate) the report, click Save and Run.

     Note
     If you have clicked Save and Run, the generated report appears on the Generated Reports tab.