Creating a Total Row in a Custom Report

[Tacosc]

I created a custom report that shows resource groups on the vertical axis and then has “count” columns that show how many late, future, on schedule, and total tasks that each resource group has. What I want is a row on the bottom of the report that totals all of the “count” columns so I can see how many TOTAL late, future, on schedule, and total tasks there are for the project.

I tried creating another custom field but I cannot get the field to show as a row, only as a column on the report.

Any suggestions?

I would like to do this in project and avoid exporting to excel because this report will be used weekly on up to 50 timelines. If you have a solution in excel please provide a streamlined way to do it. Thanks!

 

[SkipVought]

HI,

In the event that this cannot be done as you need in Project, please post your requirements, based on your export file, in forum707, for a VBA solution in Excel.

BTW, no one will have a handy dandy solution to your particular requirements, although an Excel PivotTable might come pretty close.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[JulieInMaine]

What release of Project are you using - did you create the custom report in Project or in Excel?