[]
        
(Showing Draft Content)

Group Data

Grouping is used to combine the rows based on certain values in one or more columns. If you group the data based on one column, all the rows with the same column values are grouped into one section. Adding groups to a table makes it easier to summarize and analyze the complex data in reports.

For example, the report shown below consists of a table displaying the 20 highest claim payouts.

Top 20 Claim Payout Sample Report

However, you want to summarize the claim payouts based on the policy type in the report, that is, into New and Renewal. This will help you organize the data in the report and improve its understandability.

For more details, refer to the below section that explains the step-by-step process to add groups in a table.

To Add a Group to Table Data Region

Follow the below steps to add a group to a table.

  1. Click anywhere inside the table to make the Groups pane appear on the right side of the table.

    Table Group Pane

  2. Drag and drop the desired field from the Data tab to the Groups pane. For example, use the PolicyType field to group the data based on the row based on the policy type values.

    Grouping data based on specific column in a table

    This adds a Group Header and Footer above and below the details row as shown, and sets the Grouping Expression property to in the Properties panel.

    Table after grouping the data

    Note: Alternatively, you can add a group by selecting the Group > Insert Group option from the context menu. Also make sure to set the Grouping Expression property in the Properties panel to .

  3. Merge the cells in the Group Header row by selecting the Cells > Merge Cells option from the context menu and enter the following expression in the Value property as PolicyType = .

    For more information, see the Merge Cells article.

  4. In the Group Footer row, select the cell falling in the Premium Amount column and enter the below expression in its Value property as {Sum(PremiumAmount)}.

    This will add a summarized value for the premium amount at the end of each section.

    Adding Expression in Table Control

  5. Similarly, select the cell falling in the Payout column and enter the below expression in its Value property as {Sum(Payout)}.

    This will add a summarized value for the payout at the end of each section.

    Adding Expression in Table Control

  6. Additionally, you can enter the text, 'Sub Total', in the Group Footer cell of the Region column.

  7. Preview the report.

    Grouping in report