Reporting Services - Calculating row totals/percentages in a table

Question

I am trying to calculate totals for each row as well as a percentage of the overall total.

Right now I have a table like this:

Blah    Col1    Col2    Col3
-----------------------------
ABC      1        1      1
DEF      2        2      3
-----------------------------
Total    3        3      4

And I want it to include totals/percentages like so:

Blah    Col1    Col2    Col3    Total    %
--------------------------------------------
ABC      1        1      1        3     30%
DEF      2        2      3        7     70%
--------------------------------------------
Total    3        3      4        10    100%

I know I can do the calculations in the SQL query, but the stored procedure is rather complicated so I'd like to avoid that if possible. So I'm wondering if there's a simple way to achieve this in SSRS.

Right now I just have a row group for each Blah which I use to calculate column totals.

Answer 1

I added a Totals Row for my matrix, then I referenced the totals textbox (textbox 8 in my case) for the column and I did:

Sum(Fields.FieldName.Value)/ReportItems!Textbox8.Value

I hope this makes sense!