add footer row and aggregate.