Get the subtotal of a group? (Report Builder 3.0) RRS feed

  • Question

  • I know I can get the subtotal of my DataSet1 for a specified column, and throw that into it's own column. I just have to specify the Dataset at the end of my call to SUM. Is it possible to do the same for a column in a tablix group?


    Monday, December 3, 2012 11:23 PM


  • Figured it out -- and it seems obvious now.
    Say you right-clicked on your group in the grouping pane, went to properties, and saw it's name was MyGroup.
    To get the Sum of everything in that group, you could do -- Sum(SomethingWeWantToCount, "MyGroup")
    Tablix positioning seems to determine whether it's a subtotal or total.

    • Marked as answer by SuperSturgill Thursday, December 6, 2012 9:58 PM
    Thursday, December 6, 2012 6:00 PM