Using Total Group Options in Report Builder

From SmartWiki
Revision as of 10:18, 19 June 2014 by Ciaran Donnelly (talk | contribs)

Jump to: navigation, search

Template:UnderConstruction The Total Group By options are intended to make it easier for users to implement aggregation or grouping in reports, and to get overall totals displayed. In the example below the report is pulling in information related to Organizations, and is providing overall totals on the number of companies based within country and then within States.

TotalGroup.png

The required steps when configuring these type of reports are . . .

1. Specify columns to be Total Group by: Users can set as many as they want but they'll have to be set in order that the groupings will work. For example, if you want to group first by Country then have further breakdowns based on State/Province then you would have the Country column before the State/Province column, and select the "Total Group by" option against both. TotalGroup1.png

2. Specify a column to Display Total Label: User must define a column to have the label for the total captions or else the report will give errors when run.


3. Specify columns for aggregations (eg. Total Group Sum, Total Group Count, Total Group Average, Total Group Standard Deviation)

Retrieved from ‘https://wiki.smartsimple.com/index.php?title=Using_Total_Group_Options_in_Report_Builder&oldid=22235’