Creating Totals Row in Custom Report

Home Forums Discussion Forum Creating Totals Row in Custom Report

Viewing 3 reply threads
  • Author
    Posts
    • #374111
      TacoSC
      Guest

      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 “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!

    • #374169
      Larry Christofaro
      Participant

      I don’t understand your report completely but have you tried two separate reports that are right above/below each other? One of them would be by group and the other would be a totals summary, and then line them up. Just something to generate some thoughts…??

    • #374386
      TacoSC
      Guest

      Larry,

      I like the two tables idea. I have the top table but how do I create a totals summary table like you are suggesting? I struggled with this.

    • #374397
      Larry Christofaro
      Participant

      Again, I don’t know the entire context of the report but if you create a table and set Outline Level to Project Summary that should work. Now, I just took a quick look at reports and creating a table using resources doesn’t give you a Outline Level option so that might not work in that case. Maybe use a group that contains only one entry (like Group)? Net is that my original answer might not have been correct in your situation. Good luck…

Viewing 3 reply threads
  • You must be logged in to reply to this topic.