2-level subtotals?
 

I have data containing a project number and a project manager number, is
there a way to subtotal it by project, and by manager?

Manager-A
project-1 total
project-2 total
project-3 total
Manager-A total

Manager-B
project-4 total
project-5 total
project-6 total
Manager-B total

2-level subtotals?
 

Sort firts by anamager then by Project. Now create your first subtotal on
Manager. Now create subtotals again but this time on Project 9change the
Subtotal On drop down. The most important thing to do is to uncheck "Replace
Current Subtotals". You can nest up to 7 levels of subtotals.

--
HTH...

Jim Thomlinson


"dlw" wrote:

I have data containing a project number and a project manager number, is
there a way to subtotal it by project, and by manager?

Manager-A
project-1 total
project-2 total
project-3 total
Manager-A total

Manager-B
project-4 total
project-5 total
project-6 total
Manager-B total

2-level subtotals?
 

Schweet!! Thank you!

"Jim Thomlinson" wrote:

Sort firts by anamager then by Project. Now create your first subtotal on
Manager. Now create subtotals again but this time on Project 9change the
Subtotal On drop down. The most important thing to do is to uncheck "Replace
Current Subtotals". You can nest up to 7 levels of subtotals.

--
HTH...

Jim Thomlinson


"dlw" wrote:

I have data containing a project number and a project manager number, is
there a way to subtotal it by project, and by manager?

Manager-A
project-1 total
project-2 total
project-3 total
Manager-A total

Manager-B
project-4 total
project-5 total
project-6 total
Manager-B total