Post reply

Problem with grouping

  • February 9, 2015 at 8:39 am

    #294596

    I have a report which I would like to show department/detail line 'fte' numbers (full-time employees)(which it does), department averages below the detail lines of the department (which it does, using a separate dataset/lookup expression), manager averages below the detail and group lines for that manager. This last part is what I'm struggling with. I am calculating the manager-level averages correctly (via a lookup to another dataset), but I can't seem to set up the group properly and all the manager level averages are appearing at the end of that report section. I'm just trying to get this working for the first column, ultimately all columns will have manager averages.

    Any suggestions would be appreciated. Like so many, I don't have any training with this...but I am learning!

    Below are some screenshots of the design view and report views showing the problem.

  • April 20, 2015 at 1:24 am

    #1791934

    you have added the avereage column in wrong place.

    Right click on the SeniorMgGrp and ADD TOTAL --> After,

    U ca change to TOtal To Avg after adding the Total Row.

    Hope this Helps:)

  • April 20, 2015 at 6:38 am

    #1791997

    Thanks!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply