Reporting services: Total and percentages for each row

Question

I want a result to look like this (converting from a solution in Excel to reporting services):

Campaigns      Success      Not Success      Total      Success %     Not sucess %
Campaign 1     1            4                5          20%           80%
Campaign 2     4            4                8          50%           50%

How do I accomplish this task? I can add the Total column, without any problems - but I don't know how to add the Success % and Not success % columns.

Answer 1

I think to add new columns you just need to right click and add a new column?

For the "=Details" field of the Success % column, right click and select "expression" to get to the expression editor. Then enter the following expression

=(Fields!Success.Value/Fields!Total.Value) * 100

For the Not success column do similar except your expression would be

=(Fields!NotSuccess.Value/Fields!Total.Value) * 100

(obviously the names of the actual database fields may be different in your situation)