I have defined a calculated member [myAvg] in my Analysis Services databases.
Next, I created a report using a tablix with
- in the value field of the details row : Fields!myAvg.value
- in the value field of the parent group row : Aggregate(Fields!myAvg.value)
As a result, my report runs forever .. until hitting an out of memory exception.
When I change the Aggregate function into a 'avg' function, the report runs in a few seconds. But this gives me not the results I want.
Is there any special syntax element to add, or dataset setting to apply in order to work with the aggregate function ?