Grand Total

[gnc2004]

I have several departments in my report. Each department has 4 different sub-totals (one column for cash, one for check, etc). How do I make it total those four columns to make a total for each department? In the report footer there is a grand total that totals each column from all the departments.

 

[Rich]

You should normalise your data before going any further, one field to list the value and another which defines the transaction