View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
cyn cyn is offline
external usenet poster
 
Posts: 7
Default 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