Aggregation of Aggregate Functions

• suri.yalamanchili

  SSCommitted

  Points: 1645

  More actions

  March 30, 2010 at 4:06 pm

  #220732

  Hi ALL,

  I am trying to get the percentage value in a matrix report in SQL 2005. I need to a way around the aggregation of aggregate functions in the expression box. I am trying to use Sum(Count(ItemID)) which fails as expected. Whats the loop around this?

  Thanks,

  Ninja

• denglishbi

  SSCrazy Eights

  Points: 8831

  More actions

  March 31, 2010 at 8:37 pm

  #1143604

  This has finally been resolved in SSRS 2008 R2 "Calculating Aggregates of Aggregates" http://technet.microsoft.com/en-us/library/ms170438(SQL.105).aspx

  For the time being you could probably setup a Function in the Code section and then pass in your values. Something along the lines of this example http://stackoverflow.com/questions/213002/calculating-grand-totals-from-group-totals-in-reporting-services.

  ----------------------------------------------------------------------------------------
  Dan English - http://denglishbi.wordpress.com

• suri.yalamanchili

  SSCommitted

  Points: 1645

  More actions

  April 1, 2010 at 1:43 pm

  #1144430

  Thanks