How to add a second group by

[erics]

Hi there,
I've written a quick sales report, and I'm trying to have total by team and total by region.
I've done this before, but when trying to do it now, I can group by both. However when I try to sum the amount, it only does it by region.
Any ideas what I'm missing?
Thanks!

[MFGF]

Hi there,
I've written a quick sales report, and I'm trying to have total by team and total by region.
I've done this before, but when trying to do it now, I can group by both. However when I try to sum the amount, it only does it by region.
Any ideas what I'm missing?
Thanks!

Hi,

Assuming you are using the Aggregate button on the toolbar, I'd expect you to get summary footers for all previously grouped items (plus an overall footer for the report). If not, something odd is going on in your report...

MF.

[Grayson_Basil]

Hi there,
I've written a quick sales report, and I'm trying to have total by team and total by region.
I've done this before, but when trying to do it now, I can group by both. However when I try to sum the amount, it only does it by region.
Any ideas what I'm missing?
Thanks!

In addition to the above comment

Try putting the region and team at the far left, then group, then total.