Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PivotCharts and series order | Charts and Charting in Excel | |||
Print order of worksheets | Excel Discussion (Misc queries) | |||
How do I copy an outline w/ subtotals & paste just the subtotals | Excel Discussion (Misc queries) | |||
Maintaining a default worksheet order | Excel Discussion (Misc queries) | |||
Making Excel Calculate In Correct Order | Excel Discussion (Misc queries) |