Multiple Subtotals
 

Is it possible to add a multi-layered subtotal? My data includes fields
Region, Territory, Sales Rep, Sales. I'd like to have a sub-total for each
of the first three fields but can't figure out how to add more than one.

Thanks.

- John

Multiple Subtotals
 

You do them from the inner to the outer or outer to the inner - I haven't
done it in a while, so I can't recall. But you apply the first one, then
when you do the subsequent ones, you uncheck replace subtotals in the
wizard.

So try it inner to outer and if that doesn't work, try it the other way.
Anyway, it can be done.

--
Regards,
Tom Ogilvy

"John Michl" wrote in message
...
Is it possible to add a multi-layered subtotal? My data includes fields
Region, Territory, Sales Rep, Sales. I'd like to have a sub-total for
each
of the first three fields but can't figure out how to add more than one.

Thanks.

- John

Multiple Subtotals
 

Use outer to inner to create hierarchical sub-totalling

Cheers
Nigel

"Tom Ogilvy" wrote in message
...
You do them from the inner to the outer or outer to the inner - I haven't
done it in a while, so I can't recall. But you apply the first one, then
when you do the subsequent ones, you uncheck replace subtotals in the
wizard.

So try it inner to outer and if that doesn't work, try it the other way.
Anyway, it can be done.

--
Regards,
Tom Ogilvy

"John Michl" wrote in message
...
Is it possible to add a multi-layered subtotal? My data includes fields
Region, Territory, Sales Rep, Sales. I'd like to have a sub-total for
each
of the first three fields but can't figure out how to add more than one.

Thanks.

- John