Last inner row in nested subtotal falls below outer subtotal.

W

-Wes

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top