How to display total based on group totals?

• Shree-903371

  SSCommitted

  Points: 1930

  More actions

  January 24, 2012 at 8:09 am

  #251799

  Hello,

  I need total based on a group. For example I have

  Salesperson Date Daily Sales

  —————————————————

  Homer Simpson 93

  07/01/2007

  07/02/2007

  Bart Simpson 13

  07/01/2007

  07/02/2007

  Total 106

  I need total to be 106, but when I use Sum(Fields!DailySales), it is giving me 212. I thought of using runningvalue function but it is giving me error. Can anybody please help me?

• Possinator

  Hall of Fame

  Points: 3422

  More actions

  January 24, 2012 at 4:01 pm

  #1438010

  Did you try simply adding a total row to your group? If it is grouped properly, the sum by group should work fine. Right click the group name in the RowGroup box, select Add Total.

  [font="Courier New"]Looking for a Deadlock Victim Support Group..[/font]

• Daniel Bowlin

  SSC-Dedicated

  Points: 34566

  More actions

  January 25, 2012 at 7:08 am

  #1438221

  I wrote a blog with a solution to this problem here:

  http://www.bidn.com/blogs/Daniel/ssas/1766/ssrs-use-row_number-to-resolve-datasets-with-different-levels-of-aggregation

  I hope this helps.