What are Groups?
Groups are used to combine functions (e.g. Sum, Count, Max, Min) to group the results based on the select field.
NOTE: To use the Build export function to specify groups in an export. The export needs to have been created by a template or by the Build export function. This will not work for any export that has be build using Custom SQLs
Adding Groups
Groups can be specified for the export.
- Select the Options button at the top of the command screen,
- From the drop down menu select Groups.
- Once the Export Totals/Groups screen is displayed, fields from the selected tables can be selected for groups.