View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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