Display Totals and Subtotals to show summarized values for a column or group in tablix. The Totals displays a summarized value for all the rows in the data region and the Subtotals displays a summarized value for each group instance. You can choose which function to use for computing the Totals and Subtotals values from SUM, AVG, COUNT, MIN, MAX, etc.
The easiest way to display totals or subtotals in a tablix is through the Tablix Wizard. However, you can also use the Cell Context Menu or the Group Editor to show totals and subtotals. For more details on each of these, refer to the following sections -
The Tablix Wizard is the primary way to display totals and subtotals in a tablix. The wizard appears automatically when you drop the Tablix data region onto the design area or click the data region in the Report Toolbox. You can also use the Configure button to open the Tablix Wizard. For more information on Tablix Wizard, see the Tablix article.
The Layout Options in the wizard provides you various settings related to totals and subtotals for the row and column groups. By default, the Totals and Subtotals use the COUNT function.
To display totals for row or column group, choose from the following options:
To display subtotals for row or column group, choose from the following options:
The cell context menu in a tablix displays totals and subtotals based on the group hierarchy. You can access the following totals options by right-clicking the cell in the Tablix data region. If you right-click a cell associated with a parent group, it will display totals. Similarly, if you right-click a cell associated with a child group, it will display subtotals.
By default, Totals and Subtotals use the SUM function.
The Group Editor in the Report Toolbox shows the row and column hierarchies for the currently selected Tablix data region. It also provides you options to display totals and subtotals to the chosen group in the editor. If you right-click a cell associated with a parent group, it will display totals. Similarly, if you right-click a cell associated with a child group, it will display subtotals. By default, Totals and Subtotals use the SUM function.
To show totals or subtotals in a Tablix data region, click the Vertical Ellipsis icon next to the row or column group, and choose from the following options.