Total of sums

[George]

Hi,

I would like a report that totals firstly each clients cashflows for the
month and secondly totals the every cashflow across all clients for the
period.
I seem to be able to list each clients name and their net cashflows (using
the expression "=Sum(GrossAmount)") for the period but the second total
adding each of these net amounts up i am having trouble with.

Any ideas?

Thanks
George

 

[Marshall Barton]

I would like a report that totals firstly each clients cashflows for the
month and secondly totals the every cashflow across all clients for the
period.
I seem to be able to list each clients name and their net cashflows (using
the expression "=Sum(GrossAmount)") for the period but the second total
adding each of these net amounts up i am having trouble with.

You can use the exact same expression in a text box in the
period group footer section.

If you want a grand total across all periods in the report
use the same thing again in the Report Footer section.

 

[George]

Perfect thanks Marshall. Report footer total was the one i was after.
George