Group totals in list.

[calson33]

Hello,

I have a list which I sectioned so that the grouped items (A person and their base info) are on top, and the details (tasks) are listed under this. I need to total up the hours so that there is a summary at the end of each person's task details.

however, when I put a total summary on the list, it only does it for the entire list and not each group.

Anyone have any ideas what I am missing?

Thanks!
John

[psandhya408]

try to use group span

[Lynn]

Personally I think grouping is better than sectioning. You can create a group header and then unlock the report to drag the grouped items in there. You can set the Column Titles property of the list to "At start of details" and then it looks like a sectioned report, but easier to work with (IMHO). You can split/merge the headers and footers which is handy to line things up the way you want to. I don't think you can split section headers. Perhaps it is 6 of one, half-dozen of another.

But with either sectioning or grouping, you can get the subtotals by going to List Headers & Footers, creating the group footer, and then dragging in the summary elements in there. You would have gotten group and overall footers automatically if you first did the grouping and then selected the summary option for your metrics, but with sectioning it only gives you the overall footer without the group footer. Silly.

Group span is to control how grouped items repeat (or not) along rows, so I don't think that is the right thing for your problem.

[calson33]

Brilliant. Thanks Lynn!

It's probably the way I was doing it, but it seemed much harder than it needed to be..