Subtotals in my worksheet are not dropping in the correct order:
territory # product # $$$
100 40 5
100 40 5
100 50 20
First I subtotal product number, totals of prod.# 40 is 10 and 50, 20. when
I subtotal again to get a total of territory, prod # 50 goes below the
territory subtotal, but the line it is subtotalling is still above & included
in the territory total.

Help?

Maybe...

Multilevel subtotals are in the wrong position in Excel 2002 and in Excel 2003
http://support.microsoft.com/default...b;en-us;831824



SPC wrote:

Subtotals in my worksheet are not dropping in the correct order:
territory # product # $$$
100 40 5
100 40 5
100 50 20
First I subtotal product number, totals of prod.# 40 is 10 and 50, 20. when
I subtotal again to get a total of territory, prod # 50 goes below the
territory subtotal, but the line it is subtotalling is still above & included
in the territory total.

Help?

--

Dave Peterson

I'm not sure what you mean, as the link to the page you posted 'wasn't found.'
Did you mean I can only subtotal from a certain position (first column)? If
so, would that mean I can only have the one subtotal?

"Dave Peterson" wrote:

Maybe...

Multilevel subtotals are in the wrong position in Excel 2002 and in Excel 2003
http://support.microsoft.com/default...b;en-us;831824



SPC wrote:

Subtotals in my worksheet are not dropping in the correct order:
territory # product # $$$
100 40 5
100 40 5
100 50 20
First I subtotal product number, totals of prod.# 40 is 10 and 50, 20. when
I subtotal again to get a total of territory, prod # 50 goes below the
territory subtotal, but the line it is subtotalling is still above & included
in the territory total.

Help?

--

Dave Peterson