Share via


How to: Add a Total to a Group or Tablix Data Region (Report Builder 3.0 and SSRS)

You can add totals in a tablix data region for a group or for the entire data region. By default, a total is the sum of the numeric, non-null data in a group or in the data region, after filters are applied. To add totals for a group, click Add Total on the shortcut menu for the group in the Grouping pane. To add totals for an individual cell in the tablix body area, click Add Total on the shortcut menu for the cell. The Add Total command is context-sensitive and enabled only for numeric fields. Depending on the tablix cell that you select, you can add a total for a single cell by selecting a cell in the tablix body area or for the entire group by selecting a cell in the tablix row group area or the tablix column group area. For more information about tablix areas, see Understanding the Tablix Data Region (Report Builder 3.0 and SSRS).

After you add a total, you can change the default function Sum to a different aggregate function from the list of built-in report functions. For more information, see Aggregate Functions Reference (Report Builder 3.0 and SSRS).You can create and modify report definitions (.rdl) in Report Builder 3.0 and in Report Designer in Business Intelligence Development Studio. Each authoring environment provides different ways to create, open, and save reports and related items. For more information, see Designing Reports in Report Designer and Report Builder 3.0 (SSRS) on the Web at microsoft.com.

To add a total for an individual value in the tablix body area

  • In the tablix data region body area, right-click the cell where you want to add the total. The cell must contain a numeric field. Point to Add Total, and then click Row or Column.

    A new row or column outside the current group is added to the data region, with a default total for the field in the cell you clicked.

    If the tablix data region is a table, a row is automatically added.

To add totals for a row group

  • In the tablix data region row group area, right-click a cell in the row group area for which you want totals, point to Add Total, and then click Before or After.

    A new row outside the current group is added to the data region, and then a default total is added for each numeric field in the row.

To add totals for a column group

  • In the tablix data region row group area, right-click a cell in the column group area for which you want totals, then point to Add Total, and click Before or After.

    A new column outside the current group is added to the data region, and then a default total is added for each numeric field in the column.