I have a matrix that calculates averages but I need to add a total of the averages at the end of the matrix. Now if I use =sum(avg(FieldName!.Value), it does not work since SSRS does not support aggregate of aggregate. Please help how can I sum the averages. My matrix looks like below Product Type Interest Income Fees Earned Average Balance Auto $105.45 $172.06 $561.32 Residential $2,706,305.07 $29,996.91 $406,759.58 Commercial $723,965.83 $184.85 $1,363,393.48 Total $3,430,376.35 $30,353.82 xxxxxxxxxxxxxxx I need the sum of the average balance where the xxxx is. The amount seen in the average balance column are the averages.

hello, one way is to include the average balance via a subquery of each product within the query: select product, interest, fees, (select avg(balance) from temp where product = t.product) average_balance from temp t And then in the report simply sum up that column

Thank you very much for the reply but modifying the query would take a long time just because the way the query is structured. Is there another way I can do in the SSRS or BIDS? May be user defined code or something. Thank you.

I think you need to do something like, running sum and performing average. Thanks KumarKG, MCTS