My records have the fields State and City. I’m having trouble creating a report that totals the costs for each city and the costs for each state (which is the sum of the costs for each state). I want the report to look as follows:

Tot cost is a summary field that totals the field cost.

State1

City A Tot cost

City B Tot cost

Subtotal Tot cost

State2

City E Tot cost

City F Tot cost

Subtotal Tot cost

Grand total Tot cost

To do this I’ve tried the following layout:

Sub-Summary sorted by State (leading)

Sub-Summary sorted by City (leading)

Sub-Summary sorted by City (leading)

Trailing Grand Summary

But this doesn’t work. Any suggestions?

To do this I’ve tried the following layout:

Sub-Summary sorted by State (leading)

Sub-Summary sorted by City (leading)

Sub-Summary sorted by City (leading)

Trailing Grand Summary

Assuming you meant:

Sub-Summary sorted by State (leading)

Sub-Summary sorted by City (leading) #

Sub-Summary sorted by State (trailing) #

Trailing Grand Summary #

and that the summary field is in each one of the three parts marked with # above, it should work - provided your records are sorted by State and by City.

Thanks. That did the job.