Summarize Report Data

Your report data is summarized in columns displaying the sum/average/max/min/count of numeric values.
 
To enable data summarizing in columns, you have to add summable fields and select summarizing methods for them in the value section. Summable fields are numeric fields containing values for which you want to know the count/ average/sum/ the largest or the smallest value. Summable fields are shown at all grouping levels as well as at the grand total level.
 
To add a summable field
 
1. On the page for configuring report parameters, click the Customize button.
 
2. In the values section, click the Select an option box, and then select a numeric field for which you want to summarize data.
 
The selected field is displayed in the values section.
 
3. To select a summarizing method for the field, click the calculation option box to the right of the field, and then select one of the available summarizing options from the list. By default, the SUM option is selected as a summarizing method for fields added in the value section.
 
4. If you need multiple summable fields, add and configure them similarly.
Note: The order in which you add summable fields determines the order of columns in which your report data is summarized. To reorder fields, you have to delete them and add again in a particular order.  
5. Generate the report to see the data summarized in columns formed by the selected summable fields and at the grand total level.  
 
To remove a summable field
 
1. On the page for configuring report parameters, click the Customize button.
 
2. In the values section, click the cross icon next to the summable field you wish to remove.
 
 
More information
Summarizing Methods