Grand total on grouped report?

[dmon2010]

Hello,

I have a report that has 2 groups, a "Z" group and a group without lettering.

The last field in each group is "Price". Below each group I have the following:

Total Price (which sums all the prices in each group) =Sum([price])
Total after discounts (which is the "Total Price" * .90, or a 10% discount) =[TotalPrice]*0.9
Tax (which is a .07 % tax of the "total after discounts") =[PriceAfterDiscount]*0.07
Total Due (which addss the "Total after discounts" to "tax") =[PriceAfterDiscount]*1.07

What I'd like to do is be able to sum the "Total due" for both groups and come up with a "Grand Total".

Is there some way to do this?

Any help is appreciated.

Thanks.

[June7]

Aggregate calcs must reference fields, not textboxes. So do record level calcs in report RecordSource as much as possible.

What is PriceAfterDiscount - a textbox or a field?