PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Crashes Last inner row in nested subtotal falls below outer subtotal.

Reply

Last inner row in nested subtotal falls below outer subtotal.

 
Thread Tools Rate Thread
Old 10-11-2004, 11:22 PM   #1
=?Utf-8?B?LVdlcw==?=
Guest
 
Posts: n/a
Default Last inner row in nested subtotal falls below outer subtotal.


How do I get the last inner row in a nested subtotal to remain within the
outer subtotal? Example, Column A is Projects and Column B is Tasks. I want
to subtotal all like tasks under each project, then subtotal the projects.
For example:
Data:
Project 1 Task A
Project 1 Task A
Project 1 Task B
Project 2 Task C
Should should subtotal to look like:
Task A
Task A
TASK A (subtotal)
Task B
TASK B (subtotal)
PROJECT 1 (subtotal)
Task C
TASK C (subtotal)
PROJECT 2 (subtotal)

What I'm getting is:
..
..
..
Task C
PROJECT 2 (subtotal)
TASK C (subtotal)

  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off