| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Subtotal placement issue
I am running Excel 2003 SP3.
When calculating a subtotal on location, then by salesperson, excel is inserting the subtotal for the salesperson after the location. I would expect to see the following: Salesperson 1 subtotal Salesperson 2 subtotal Location subtotal What I am seeing is: Location subtotal Salesperson 2 subtotal Salesperson 2 subtotal Does anyone know why this is happening. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Subtotal placement issue
Maybe...
Multilevel subtotals are in the wrong position in Excel 2002 and in Excel 2003 http://support.microsoft.com/default...b;en-us;831824 simmerdown wrote: I am running Excel 2003 SP3. When calculating a subtotal on location, then by salesperson, excel is inserting the subtotal for the salesperson after the location. I would expect to see the following: Salesperson 1 subtotal Salesperson 2 subtotal Location subtotal What I am seeing is: Location subtotal Salesperson 2 subtotal Salesperson 2 subtotal Does anyone know why this is happening. -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Subtotal placement issue
Hi, without seeing a copy of your database, I wonder if you have sorted
first? First on location then salesperson. "simmerdown" wrote: I am running Excel 2003 SP3. When calculating a subtotal on location, then by salesperson, excel is inserting the subtotal for the salesperson after the location. I would expect to see the following: Salesperson 1 subtotal Salesperson 2 subtotal Location subtotal What I am seeing is: Location subtotal Salesperson 2 subtotal Salesperson 2 subtotal Does anyone know why this is happening. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Multiple Subtotal Placement | Excel Worksheet Functions | |||
| Pivot subtotal issue | Excel Discussion (Misc queries) | |||
| pasting to subtotal lines without replacing hidden -non-subtotal l | Excel Discussion (Misc queries) | |||
| Tab placement | Excel Discussion (Misc queries) | |||
| Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions | |||
Linear Mode
