I have an SSAS MDX query that uses a calculated member; when adding the subtotal in the report I would like to rely on SSAS doing to aggregation rather than the incorrect sum SSRS is trying to do. But when I use =Aggregate(Fields!x.Value) I dont get anything back, the cell is blank. Why? Javier Guillen http://www.msbicentral.com/Blogs/JavierGuillen.aspx

If you are trying to use a calculated member to perform the aggregate, why then do you need =Aggregate(Fields!x.Value) ? Unless I'm mistaken that you're performing the aggregation inside the calculated member?

Yes, you are correct. Sorry I forgot to mention that what I need is the TOTAL aggregate (for the (all) member). SSRS doesnt fall back and uses the (all) member for the total/subtotal rows, instead it does a straight (SUM, MIN, MAX...) which is incorrect. So we end up having to recreate the calculation all over again as an SSRS expression which is not optimal as we have the same calculation in two places (SSAS as well as SSRS) So I thought using the SSRS Aggregate will force the tablix cell to fall back and use the data source aggregation instead of trying to compute it itself Any ideas in how to get around this? Javier Guillen http://www.msbicentral.com/Blogs/JavierGuillen.aspx