Does the footer exist at all? All you need to do is copy the expressions from the header's cells to the footer's cells, delete the expressions from the header's cells, then hide the header row.
If you don't have a footer, right click your header row, choose Edit Group, and check "Include Group Footer.