Since a Grand Summary would also produce a count of 30, I'm not sure what you mean by:
I don't want to use Grand Summary since I want to total each heading's totals the same as this heading's.
Can you provide an example that produces a result that is different from what you would see in a Grand summary?
Sure thing. Here's the last page--it's where the Trailing Grand Summary plops the total. What I need is for each heading's totals to appear before the following one, so the totals are heading-by-heading.
Assuming that each heading is a sub summary part, you need only put the very same summary field into this sub summary part to get a total of all records grouped with that sub summary part.
More specifically, you can make matching "print above" and "print below" sub summary parts and put the summary field in the "print below" part.
Ah! A light bulb moment.
That's what frustrated me: I had tried doing that very same thing (with "Print Above") but FileMaker barked at me saying that I couldn't reuse the same field for a sub summary, i.e., "A Sub-summary part for this field already exists." But, after trying your suggestion using "Print Below", it worked.
I'm going to have to find definitive info on the difference since I never encountered that before. Thank you VERY much for your help!
I can't reselect the "best answer" option either, but it's no big deal.
The point of the error message is that you already had a sub summary part with those specifications. If you had not tried to add a new sub summary part at all, but just added the summary field to your existing sub summary part, you would have seen the correct total, but located above the group of records as part of the "sub header" instead of below the group as generally will make more sense to the person reading the report.