SSRS 2008 Matrix - Problem with Calculating Percentage using Sub Total
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
May 6th, 2012 6:25pm

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
May 6th, 2012 7:23pm

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")
May 6th, 2012 7:31pm

Hi Dasari, Thanks for your advise/solution, I will try it and get back to you. agb
May 7th, 2012 4:12pm

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
May 7th, 2012 4:13pm

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