Hi, I am attempting to get the percentage of a particular item based on the item total divide by the group total in SSRS Matrix. I am new to this forum and I have been searching this particular forum and i have found very similar issues to mine. Below is an image i pasted hoping I could explain my issue a lot clearer. Thanks in advance. agb

Hi There, in col4 right click and write the expression like this =(Fields!Col4.value)/SUM(Fields!Col4.value,"YourGroupName") so that will be 10/150=0.66 and multiply by 100 so 0.66 * 100 =6.7% I hope this post will help you and all the best.Dasari

Hi There Would you like to calculate the percentage of each column with its relevant total value ? For example All column three (col3) values will be divided by 1500 and all column 4(col4) values will be divided by 150 etc Then what you could write expression like this =Sum(Fields!Net_Amount.Value)/sum(Fields!Net_Amount.Value,"Fiscal_Year") Where "Fiscal_Year" is your column group inside the matrix. I am putting some screenshot for your help 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")

Hi Dasari, Thanks for your advise/solution, I will try it and get back to you. agb

Hi Syed, thanks for your response, I will try your version and mark my thread as solved when i get it to work. Thanks, agb

Hi There Not a problem if you still have any issue please let us know Many Thanks Syed Qazafi Anjum

Hi Dasari, The solution you provided was extremely helpful. It worked flawlessly the first time I executed the code. It also worked after tweaking the code so i could apply it at the group total level. Basically took your same code and made minor changes. Thanks again Dasari. agb

Hi ArtSQL, I am glad my idea solved your problem. All the best.Dasari