Hi Syed, Thaks for reply. i have tried that but in all the rows it is showing 100% Actually in my matrix netAmout column is the sum of previous 4 columns value and that value i am deviding by sum of netAmount Year wise. Thanks and regards, Biru

Hi , Use this Expression =(Fields!Net_Amount.Value)/Sum(Fields!Net_Amount.Value,"Fiscal_Year")Now you insert a row below outside the group and place this expression =Sum(Fields!Net_Amount.Value)/Sum(Fields!Net_Amount.Value,"Fiscal_Year") Hope this will help you !!! Sanjeewan

Hi Biru thanks for your posting. Can you please put a screenshot for your matrix data and can you also please tell me is year your row group and do you have any column group inside your matrix. Please try to provide more information so that I can help you out Many thanks Syed Qazafi Anjum

Hi Biru thanks for your posting. Can you please put a screenshot for your matrix data and can you also please tell me is year your row group and do you have any column group inside your matrix. Please try to provide more information so that I can help you out Many thanks Syed Qazafi Anjum As far as I can think of you might not be putting your Scope while dividing you sum. Please also post your expression Many thanks

hi syed, Total Unit Period Vol Contribution% 1 MT 16 MT 2.5 MT 4 MT 9 MT 100.00 APA 2012-2013 0.00 35.47 0.00 0.00 64.53 100.00 100.00 APP 2012-2013 0.00 95.80 0.00 0.00 4.20 100.00 100.00 BBL 2012-2013 0.00 85.85 0.00 0.00 14.15 100.00 100.00 BBY 2012-2013 0.00 70.94 0.00 0.00 29.06 100.00 100.00 BDL 2012-2013 12.95 0.00 0.00 0.00 87.05 100.00 100.00 CHE 2012-2013 0.00 0.00 0.00 0.00 100.00 100.00 100.00 EMP 2012-2013 0.00 0.00 6.13 5.53 88.34 100.00 100.00 GOA 2012-2013 0.00 61.97 0.00 0.00 38.03 100.00 100.00 KAL 2012-2013 12.98 12.83 4.02 0.00 70.17 100.00 100.00 KBD 2012-2013 0.00 4.74 0.00 0.00 95.26 100.00 100.00 LUD 2012-2013 0.00 83.98 0.00 0.00 16.02 100.00 100.00 MBA 2012-2013 0.00 50.66 0.00 0.00 49.34 100.00 100.00 MBD 2012-2013 0.00 0.00 0.00 0.00 100.00 100.00 100.00 MBH 2012-2013 0.00 62.05 0.00 0.00 37.95 100.00 100.00 MBR 2012-2013 0.00 0.00 0.00 1.79 98.21 100.00 100.00 MMP 2012-2013 25.00 0.00 37.50 37.50 0.00 100.00 100.00 ORS 2012-2013 0.00 84.16 0.00 0.00 15.84 100.00 100.00 PKD 2012-2013 0.00 0.00 0.00 0.00 100.00 100.00 100.00 RAJ 2012-2013 0.00 9.95 0.00 0.00 90.05 100.00 100.00 UBM 2012-2013 0.00 98.72 0.00 0.00 1.28 100.00 100.00 UBR 2012-2013 0.00 0.00 10.00 10.00 80.00 100.00 100.00 UHR 2012-2013 0.00 0.00 0.00 0.00 100.00 100.00 100.00 UMB 2012-2013 0.00 100.00 0.00 0.00 0.00 100.00 100.00 UMP 2012-2013 0.00 0.00 0.00 4.35 95.65 100.00 100.00 UUP 2012-2013 0.00 35.90 1.17 8.86 54.08 100.00 100.00 Total 2.29 36.16 0.77 0.66 60.13 100.00 in the above screenshot, in the vol contribuition column we have used total of each unit devided by total of all unit for a particular year. row grouping Short_Name4,fisicalyear thanks and regards, Biru

Hi Biru I could not see the attached screenshot please put it again and also please put the expression which you are using inside Vol Contribution% column that would be helpful to find out the problem. Can you please also explain what is the total at the bottom showing? If you have any question please let me know. Many Thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.

i have a matirx report in ssrs 2005 in which i need year wise total and i have to use that total in a column of a matirx for example; value Price Volcont A 1 5 priceA/sum in 2011 B 2 10 priceA/sum in 2011 2011 sum 15 value Price volcont A 1 1 5 priceA/sum in 2012 B 2 20 priceB/sum in 2012 2012 sum 35 can any one help me sort this issue. when i am trying to get volcont col i have put formula in that price/sum then it is deviding by the sum of all the year but i need price devided by sum year wise. thanks and regards, Biru...

Hi Biru395, I think you have to had a group by your field which have A or B values. Se you.

Hi there You just need to put this expression where you would like to calculate the perecantage =Sum(Fields!Net_Amount.Value)/Sum(Fields!Net_Amount.Value,"Fiscal_Year") Where I am assuming that "Fiscal_Year" is your row group of years please change the column and fields name according to your dataset If you have any questions please do ask. Many Thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful. =Sum(Fields!Net_Amount.Value)/Sum(Fields!Net_Amount.Value,"Fiscal_Year")