Multiple Subtotals

[John Michl]

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

 

[Tom Ogilvy]

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.

 

[Nigel]

Use outer to inner to create hierarchical sub-totalling

Cheers
Nigel