Post reply

SUM of only last gouped Data

  • March 31, 2011 at 6:33 am

    #1305922

    I would suggest writing a second query to get the summary data for the current year and UNION them together

  • March 31, 2011 at 7:39 am

    #1305966

    Put a scope qualifier in your SUM statement. Something like this (my syntax may be off)

    =SUM(Fields!ColumnToAdd.Value,"2010")

    Where "2010" is the name of the group for 2010.

    You can also just add sum directly in the group. That would show the totals for each group.

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

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