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)
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)