LO 5 report builder aggregaate function in grouping

Using LO5.0 to design a report, it works fine. But then grouping on on filed, I would like to du th esum of the data of that field in the report section footer. It doesnot work.
Yet I usetd the appropriat property.
How to fix it?