Group Footer Summary

Order Date

	Company Name	Country	Unit Price	Quantity	Total

	Order Date: 7/4/2021
	Count: 3				Sum: $440.00
	Order Date: 7/5/2021
	Count: 2				Sum: $1,863.40
	Order Date: 7/8/2021
	Count: 6				Sum: $2,483.80
	Order Date: 7/9/2021
	Count: 3				Sum: $3,730.00
	Order Date: 7/10/2021
	Count: 3				Sum: $1,444.80
	Order Date: 7/11/2021
	Count: 3				Sum: $625.20
	Order Date: 7/12/2021
	Count: 4				Sum: $2,490.50
	Order Date: 7/15/2021
	Count: 2				Sum: $517.80
	Order Date: 7/16/2021
	Count: 3				Sum: $1,119.90
	Order Date: 7/17/2021
	Count: 3				Sum: $2,018.60
	Order Date: 7/18/2021
	Count: 2				Sum: $100.80
	Order Date: 7/19/2021
	Count: 6				Sum: $2,194.20
	Order Date: 7/22/2021
	Count: 3				Sum: $624.80
	Order Date: 7/23/2021
	Count: 4				Sum: $2,464.80
	Order Date: 7/24/2021
	Count: 2				Sum: $724.50
	Order Date: 7/25/2021
	Count: 2				Sum: $1,176.00
	Order Date: 7/26/2021
	Count: 1				Sum: $364.80
	Order Date: 7/29/2021
	Count: 3				Sum: $4,031.00
	Order Date: 7/30/2021
	Count: 2				Sum: $1,101.20
	Order Date: 7/31/2021
	Count: 2				Sum: $676.00

The group footer contains cells that correspond to data columns. To display a summary value in a group footer column, set the summary item's FooterColumnName to the name of this column.

You can use the Group Footer Display Mode option to control group footer visibility:

Never — Group footers are always hidden, even if they contain summary values.
IfExpanded — Group footers are displayed for expanded groups only.
Always — Group footers are always visible regardless of the groups' expanded state, even if they do not contain summary values.
Auto — Group footers are displayed if they contain summary values and corresponding groups are expanded. Otherwise, group footers are hidden.

Did this demo address your needs?