| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtotals: Nested subtotals below higher subtotal
I am having a problem when using the automatic subtotal tool. I am
subtotaling twice, but on the second subtotal, some of the subtotals for the second item are showing up below the subtotals for the first item. This happens when there is only one second item for the first item. It then affects all highest subtotals from then on. For example: Sports Football NFC Sports Football AFC Sports Total Count 2 Football Total Count 2 (rather than) Sports Football NFC Sports Football AFC Football Total Count 2 Sports Total Count 2 Please advise if there's a workaround or if this is an Excel bug. Thanks, Rob |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Subtotals: Nested subtotals below higher subtotal
See http://support.microsoft.com/kb/831824/
"RobN" wrote: I am having a problem when using the automatic subtotal tool. I am subtotaling twice, but on the second subtotal, some of the subtotals for the second item are showing up below the subtotals for the first item. This happens when there is only one second item for the first item. It then affects all highest subtotals from then on. For example: Sports Football NFC Sports Football AFC Sports Total Count 2 Football Total Count 2 (rather than) Sports Football NFC Sports Football AFC Football Total Count 2 Sports Total Count 2 Please advise if there's a workaround or if this is an Excel bug. Thanks, Rob |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nested subtotal figures in wrong order | Excel Discussion (Misc queries) | |||
| Nested Subtotals in Excel 2002 | Excel Discussion (Misc queries) | |||
| Experienced any problems with nested subtotals using Windows XP | Excel Worksheet Functions | |||
| Problem with nested subtotals, placing secondary subtotals BELOW . | Excel Discussion (Misc queries) | |||
| why are nested subtotals coming out below outer subtotals? | Excel Worksheet Functions | |||
Linear Mode
