#1   Report Post  
Posted to microsoft.public.excel.misc
ChrisN
 
Posts: n/a
Default Nested Sub-Totals

I am trying to do a nested subtotal. The total for the last grouping in the
inner subtotal is appearing underneath the outer subtotal. Does anyone know
what would cause this? How to correct it?
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Nested Sub-Totals


Maybe...

Multilevel subtotals are in the wrong position in Excel 2002 and in Excel 2003
http://support.microsoft.com/default...b;en-us;831824

ChrisN wrote:

I am trying to do a nested subtotal. The total for the last grouping in the
inner subtotal is appearing underneath the outer subtotal. Does anyone know
what would cause this? How to correct it?


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
ChrisN
 
Posts: n/a
Default Nested Sub-Totals

We have Service Pack 1 & have now just installed Service Pack 2 and am having
the same problem.

"Dave Peterson" wrote:


Maybe...

Multilevel subtotals are in the wrong position in Excel 2002 and in Excel 2003
http://support.microsoft.com/default...b;en-us;831824

ChrisN wrote:

I am trying to do a nested subtotal. The total for the last grouping in the
inner subtotal is appearing underneath the outer subtotal. Does anyone know
what would cause this? How to correct it?


--

Dave Peterson

  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Nested Sub-Totals

Maybe you should try the registry tweak.

ChrisN wrote:

We have Service Pack 1 & have now just installed Service Pack 2 and am having
the same problem.

"Dave Peterson" wrote:


Maybe...

Multilevel subtotals are in the wrong position in Excel 2002 and in Excel 2003
http://support.microsoft.com/default...b;en-us;831824

ChrisN wrote:

I am trying to do a nested subtotal. The total for the last grouping in the
inner subtotal is appearing underneath the outer subtotal. Does anyone know
what would cause this? How to correct it?


--

Dave Peterson


--

Dave Peterson
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Totals column thinks it's 24 hr clock & shows 01h31m instead of 25h31m. Fix? StargateFan Excel Discussion (Misc queries) 4 October 16th 05 07:10 PM
Nested Subtotals in Excel 2002 KG Excel Discussion (Misc queries) 2 September 10th 05 11:51 AM
Why are my nested sub-totals are displaying incorrectly? chiefdean13 Excel Discussion (Misc queries) 1 July 20th 05 05:45 AM
Pivot Table Grand Totals Adam Excel Worksheet Functions 0 March 25th 05 04:55 PM
Nested IF statements John Simons Excel Worksheet Functions 14 February 16th 05 06:17 AM


All times are GMT +1. The time now is 05:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"