How do I get the correct order for nested subtotals
 

Subtotal 1:Data,subtotal,vendor. Subtotal 2:Data, subtotal, month. Why does
the last subtotal for month appear AFTER the subtotal for Vendor? See below.

Month Vendor Srce Amount
1 A147 APIN 116.44
2 A147 APIN 2.15
2 A147 APIN 0.19
2 A147 APIN 13.94
2 A147 APIN 1.08
2 A147 APIN 119.66
2 A147 APIN 0.56
2 A147 APIN 0.14
2 A147 APIN 38.64
2 Total 292.80
7 A147 APIN 217.94
7 A147 APIN 3.43
7 A147 APIN 0.20
7 A147 APIN 24.88
7 A147 APIN 3.55
A147 Total 542.80
7 Total 250.00

How do I get the correct order for nested subtotals
 

Maybe...

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

cyn wrote:

Subtotal 1:Data,subtotal,vendor. Subtotal 2:Data, subtotal, month. Why does
the last subtotal for month appear AFTER the subtotal for Vendor? See below.

Month Vendor Srce Amount
1 A147 APIN 116.44
2 A147 APIN 2.15
2 A147 APIN 0.19
2 A147 APIN 13.94
2 A147 APIN 1.08
2 A147 APIN 119.66
2 A147 APIN 0.56
2 A147 APIN 0.14
2 A147 APIN 38.64
2 Total 292.80
7 A147 APIN 217.94
7 A147 APIN 3.43
7 A147 APIN 0.20
7 A147 APIN 24.88
7 A147 APIN 3.55
A147 Total 542.80
7 Total 250.00

--

Dave Peterson