HelpTotals within Totals

I have a report with say two fields, market, amount. I need a report to present like this, but to do totals after line item presentation...example report looks like this. Question is, how do I do the totals part seperate from the line items??

Market amount
-- --
Texas 10.00
Texas 20.00
Texas 30.00
Boston 10.00
Boston 20.00
Boston 90.00

Totals Texas 60.00
Totals Boston 120.00You can set it up like the following by adding a Group on Market and adding a Running Total Field which Sums Amount to the Group Footer.

Market amount
-- --
Texas 10.00
Texas 20.00
Texas 30.00

Totals Texas 60.00

Boston 10.00
Boston 20.00
Boston 90.00

Totals Boston 120.00

- or -

If you know what Market is going to be, you can set up Formula Fields with the following Formula:

NumberVar intTotal
IF {Market} = 'Texas' THEN
NumberVar := NumberVar + {Amount}

- or -

There's a Formula that looks like: Sum(fld, condFld, cond). I have never used it, but I assume you can set it up simialr to:

Sum ( {Amount}, {Market}, 'Texas' )

(I didn't test this code, so you may have to tweak it a bit to work out any bugs.)|||Thanks malleyo but there's a subtle difference in the report...the footer has and entries for each market. The list of markets is dynamic (a group by field)...thus, option 1 and 2-3 aren't quite it...I have a feeling I have to use subreports.

Let me know if you have any other thoughts and thanks for your help.|||Hi Mallego
How to sum amount large than 10 ?|||ReportDude,
I guess you are right there is no option otherthan subreport, I had the same issue before and I used sub report.
But if you find better solution other than SubReport please post the solution.

Thanks,
Gragi