| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Problem with nested subtotals, placing secondary subtotals BELOW .
I some but not all spreadsheets, my nested subtotal (slsperson) is placed
below the primary subtotal (branch). It has only happened to me since upgrading to Excel 2003. I sort by Branch, slsperson, customer. Then Primary subtotal is branch (checks on replace current subtotals and summary below) and all is fine. Then when I do subtotal on Slsperson it will place (above items unchecked) the slsperson subtotal BELOW the branch. And also the levels (1,2,3) are not displaying properly. Does anyone have a suggestion for me? |
|
#2
|
|||
|
|||
|
maybe...
Multilevel subtotals are in the wrong position in Excel 2002 and in Excel 2003 http://support.microsoft.com/default...b;en-us;831824 Dawn Cameron wrote: I some but not all spreadsheets, my nested subtotal (slsperson) is placed below the primary subtotal (branch). It has only happened to me since upgrading to Excel 2003. I sort by Branch, slsperson, customer. Then Primary subtotal is branch (checks on replace current subtotals and summary below) and all is fine. Then when I do subtotal on Slsperson it will place (above items unchecked) the slsperson subtotal BELOW the branch. And also the levels (1,2,3) are not displaying properly. Does anyone have a suggestion for me? -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Nested subtotals don't work properly after applying recommendation | Excel Worksheet Functions | |||
| Nested Subtotals in Excel 2003 -Solution | Excel Discussion (Misc queries) | |||
| nested subtotals | Excel Discussion (Misc queries) | |||
| Subtotals Problem when Filtering | Excel Discussion (Misc queries) | |||
| why are nested subtotals coming out below outer subtotals? | Excel Worksheet Functions | |||
Linear Mode
