Post reply

SSRS-Adding a subgroup to a group column

  • July 29, 2014 at 12:36 am

    #296752

    Here is my scenario:

    I have a matrix report which looks like this:

    Project Hours Normalized Hours

    ProjectXYZ 10 20

    ---------------------------------------

    ProjectXYZ 20 30

    ----------------------------------------

    ProjectXYZ 30 50 <<<<<<<<<<<<<<<<<I need to add a subgroup like this that will follow each project with the summed up hours as well

    -----------------------------------------

    ProjectABC 40 50

    -------------------------------------------

    ProjectABC 10 30

    ----------------------------------------------

    ProjectABC 50 80

    It is currently parent grouped by Project, but I need to add a subgroup that will consistently follow each of the projects with their totals as well. Any help will greatly be appreciated. Thank you.

  • July 29, 2014 at 5:25 pm

    #1733418

    I think you mean a tablix, but anyway...

    If you click on one of two right columns (one of the Hours ones), you can right-click and from the context menu dropdown, select Insert Row, Outside Group Below. Then you can drop in the [Hours] and [Normalized Hours] fields and you should get SUM([Hours]) under it.

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

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