locked
SSRS Reporting Expression Sum of Groupings RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    User-629266015 posted

    I would like to "sum' the counts of a field we have grouped.

    Group = Court

    Would like to get sum of this group:

    ="Court:  " & First(Fields!Court.Value) & "   -   " & Count(Fields!Court.Value)

    Have tried the following expression, to be used in Header of page:

    =Sum(ReportItems!Court.Value, "table1_Court")

    Court = field name

    table1_Court = row group

    Monday, October 6, 2014 3:07 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote
    User-734925760 posted

    Hi,

    According to your description, you can try to add a  group variable in the Group Properties with the sum function.

    For more information, please refer to the link below:

    http://www.wiseowl.co.uk/blog/s283/group-variables.htm

    Hope it's useful for you.

    Best Regards,

    Michelle Ge

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, October 7, 2014 3:42 AM