Smartstaff, administrator
4,478
edits
Changes
no edit summary
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 the number of organizations. It is grouped initially by Country and then by State/Province.
[[Image:TotalGroupReport.png|930px]]
The report provides an overall Grand Total at the bottom of the page regardless of Country or State. In the example shown below there are 817 organizations regardless of country.
[[Image:TotalGroupReport1.png|930px]]
It also provides totals based on the first column defined as '''Total Group by'''. In our example below the first column defined as '''Total Group by''' is the Country field, so the report shows there are a total of 812 organizations within the United States. <br/>
[[Image:TotalGroupReport2.png|930px]]
It also provides further breakdown within groupings based on any additional '''Total Group by''' columns defined. In our example below we only have State/Province as the additional '''Total Group by''' column. The report shows that there are a total of 2 Organizations in Wyoming and 18 in Wisconsin, and this data is displayed within the overall country data.
[[Image:TotalGroupReport3.png|930px]]
==Configuration==
[[Image:TotalGroup1.png]]
2. Specify a column to '''Display Total Label''': User must define a column to display the label for the Total captions. If this is not defined then the report will give errors when run. In the example shown we are using the City column to display the labels.
NOTE: The Total text will always be right aligned.
3. Specify columns for aggregations: There are a number of options for aggregating the data e.g.