Aggregation of Aggregate Functions

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Business Intelligence » Aggregation of Aggregate Functions

Aggregation of Aggregate Functions

Rate Topic

Display Mode

Topic Options

Author

Message

suri.yalamanchili

Posted Tuesday, March 30, 2010 4:06 PM

Valued Member

Group: General Forum Members
Last Login: Thursday, January 31, 2013 4:02 PM
Points: 69, Visits: 539

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

Post #893396

denglishbi

Posted Wednesday, March 31, 2010 8:37 PM

Old Hand

Group: General Forum Members
Last Login: Monday, May 13, 2013 9:09 AM
Points: 347, Visits: 1,339

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

Post #894347

suri.yalamanchili

Posted Thursday, April 01, 2010 1:43 PM

Valued Member

Group: General Forum Members
Last Login: Thursday, January 31, 2013 4:02 PM
Points: 69, Visits: 539

Thanks

Post #895259

« Prev Topic | Next Topic »

Permissions