Export (0) Print
Expand All
Expand Minimize

How to: Add a Total to a Group or Tablix Data Region (Report Builder 2.0)

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 2.0).

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 Using Built-in Report and Aggregate Functions in Expressions (Report Builder 2.0).

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.

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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft