Hi My SSRS matrix table data looks like this Year 1 Year 2 Type Month 1 Month 2 Month 1 Month 2 Type1 3 2 6 5 Type2 7 3 2 5 Total 10 5 8 10 Year and month are dynamic. I want to calculate the total at the last. I tried doing sum(Fields!total.value) but it returns incorrect total. Please advise. Thanks Sriji

Hi Sriji, I have some example for you, see if they can help you out:- You can download "Total_AND_GrandTotal.rdl", "Total_AND_GrandTotal_Multiple_BenID.rdl" & "Total_AND_GrandTotal_WithFilter_NEW.rdl" rdl files. https://skydrive.live.com/#cid=15E0E13BD0545504&id=15E0E13BD0545504%21137 Note:- You need to change the datasource as per your req. Please let us know your feedback. Thanks KumarPlease do let us know your feedback. Thank You - KG, MCTS

Hi Kumar, Thank you so much. Excellent example.