Report, sub summary issue

[faaslave]

Hello all,

I have a report that is attached.

The report is for total membership of a group.

It is broken down by Region, then by Chapter, with totals.

Everything works except for the total members for each region. It works if the region happens to have only one chapter, but when the the region has more than one chapter the total does not work. The grand total works.

The lower chapter sub-summary is sorted by chapter and the lower region sub-summary is sorted by the region, just like the upper ones.

I know it must be something simple I am missing, any help on what to look for?

Thanks,

Dave

[faaslave]

I think I figured it out. I had to make a different summary field using running total and sorted by region for it to work.