You can use the DefaultGroupFooter editor to create a group footer. Use the Group by Column option to select the group column to set the group information for. You can also specify the formula type. Use the Formula property for the actual formula.

This editor is launched from the Properties window by selecting sheet in the drop-down box on the right side of the designer and then clicking on the button for DefaultGroupFooter.

The GroupFooterVisible property must be set to true to see the group footer and AllowGroup and AllowColumnMove should be set to true to allow the user to group.

From the File menu choose Apply and Exit to apply your changes to the FpSpread component and exit Spread Designer.

Return to Spread Designer Editors.