Data Browser - Viewing Site  Sector 23 Code Bank Logged in as:  Guest  


SSRS Aggregate of an aggregate
In SSRS 2008 R2 (but not earlier), you can now supposedly calculate an aggregate of an aggregate.

The syntax is: =Count(Sum(Fields!MyNumber.Value, "GroupByScopeOrField"))

HOWEVER if you are making a tablix/matrix, it doesn't appear to work. If you are grouping on multiple axes, X & Y in the grid, and then try to put an aggregate of an aggregate in the bottom row of each column, you receive this error:

The Value expression for the textbox X uses both row and column scopes or scopes from two different data axes in the same aggregate expression.

How to resolve this? I don't know. My current best guess is either don't use a tablix or go back to computing manually using custom functions or SQL like pre 2008 R2.

Created By: amos 11/18/2013 4:30:59 PM