Sum of Total of a Particular Category

[elliot315]

I have a report that consists of various subreports. It consists of Sales, Charges, Expenses and Reimbursements
in the report footer I want the sum of the Sales & Charges that were made Cash, another line for Credit Cards Totals and the other Checks total.... how do I limit the sum for each one?
This is what I have

SubReport Sales
Cash
Cash Line 1 45.00
Cash Line 2 50.00
Cash Line 3 5.00
Sum $100.00

Credit Cards
Credit Card Line 1 25.00
Credit Card Line 2 25.00
Sum $ 50.00

SubReport Charges
Cash
Cash Line 1 25.00
Cash Line 2 50.00
Cash Line 3 5.00
Sum $ 80.00

Credit Cards
Credit Card Line 1 20.00
Credit Card Line 2 25.00
Sum $ 45.00




In the report footer I want
Cash: Sum of Cash of Sales + Sum of Cash of Charges
Credit Cards: Sum of Credit Cards of Sales + Sum of Credit Cards of Charges

How do I accomplish that report Footer?