Nested Subtotals


L

Lisa C

I’ve got a file that I am currently sorting inventory $ values by a planner
code then by supplier within there. Following the instructions in excel, to
do nested subtotals so that I get the subtotal of the planner and then the
subtotals of each supplier within there, I first subtotaled by planner then
subtotaled again by supplier. When the subtotaling process is done the
layout of the outline is off and the labels for the last supplier’s subtotal
is after the subtotal of the planner instead of above it. Am I doing
something wrong?
 
Ad

Advertisements

B

Brad Vogt

If you have Access, you may want to copy the data into a table and run a
report wizard off the table to group the data and add subtotals where
desired. What you are trying to do is much easier in Access.
 
Ad

Advertisements

D

Dave Peterson

Not for me.

Brad said:
If you have Access, you may want to copy the data into a table and run a
report wizard off the table to group the data and add subtotals where
desired. What you are trying to do is much easier in Access.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top