Adding group total

  • I have table on which i inserted two groups, i want to display totals at the end of each group.

    example

    Months Days Total

    july

    ----- 5

    ----- 5

    Total 10

    june

    ------ 2

    ------ 3

    Total 5

    thanks for the help

  • Just drag your field into the group footer area of the group, when you drag a field into a group footer area, SSRS automatically assumes you want a sub-total and changes the expression to =SUM(Fields!ColumnName.Value).

    Regards,

    Nigel West
    UK

  • Column1 Column2

    MonthGroupHeader: =Fields!Month.Value

    Detail Section: =Fields!Amount.Value

    MonthGroupFooter: ="Total " =Sum(Fields!Amount.Value)

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

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