Search code examples
reporting-servicesexpressionssrs-tablixcalculated-field

Adding ratio to a SSRS matrix

I want to add an expression to each row in the ratio column. I want to divide row total by group total and show that amount in the ratio column for each row. For the first row of ratio column it should be 11/44.

enter image description here

My design tab has the following design.

enter image description here

Solution

  • Take the formula in your total row (something like Sum(Fields!Survey1.Value)) and add the group name over which you want to sum your total, giving something like Sum(Fields!Survey1.Value,"ExamGroup"). That should allow you to access the total at each row of the group, so you can get the ratio of each row with something like this:

    Fields!Survey1.Value / Sum(Fields!Survey1.Value,"ExamGroup")