Report Studio

Use the Aggregate Button to Add Simple Summaries

You can add simple summaries to the groups in a report by using the aggregate button in the toolbar. This button provides a subset of the aggregate functions available in Report Studio. In addition, a Custom option is available so that you can add your own aggregate function in the expression of the data item .

The aggregate button sets the rollup aggregate property for the data item to the selected summary aggregate, and places the data item into an appropriate footer. A footer is created for each group as well as an overall footer, unless they already exist.

To use the Aggregate Button to add Simple Summaries:

Open the report that you want.
Click the column to which you want to add a summary.
From the Data menu, click the kind of summary that you want.
Note: The Total function is valid for numeric fields. If used on non-numeric fields (Date fields for example) an error displays when you run the report.
If you want to change the summary label, do the following:

Click the label.
In the Properties pane, click the Source Type property and then click the source type that you want to use to define the label.
For example, click Data Item Value to produce a dynamic label for the summary based on data item values.
Depending on the source type you chose in the previous step, click the property below Source Type and specify the label.
For example, if clicked Data Item Value as the source type, click the Data Item Value property and click the data item that you want to use to define the label.

In lists, the summary appears as a footer . If the column to which you added a summary is grouped, group and overall summaries appear. In crosstabs and charts, the summary appears as a node.

Tips

If you want to change a summary, click it, and in the Properties pane, under Data Item, click Rollup Aggregate Function and choose a different function.
In crosstabs, you can add multiple summaries at the same level. For example, you have a crosstab with Product line as rows, Order year as columns, and Revenue as the measure. For Product line, you can add the Total summary as a header, which will total all revenue for each order year. You can then add the Average summary as a footer, which will give the average revenue of all product lines for each order year.