Total Row in a Custom Report on Project - Excel Solution?

[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 posted this in the Project forum and it was suggested I post it here as well because there may be a solution using Excel.

 

[SkipVought]

HI,

Excel versions 2007+ has a new feature called Structured Tables: INSERT > TABLES > TABLE.

when your report table is converted to a Structured Table, a context sensitive GROUP appears in the ribbon. Included is a TOTALS Row. Check that out. It will take you just a few seconds to achieve what it appears that you need.

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

 

[SkipVought]

Hello,

Our other members would benefit from a reply from you. Did you arrive at a satisfactory solution or not. If so, please share your solution for the benefit it other members.

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