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 dont know how to add the sucess % and not success % columns :/

Thanks a bunch in advance! :)

/Jesper

Answer 1

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

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

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

For the Not sucess column do similar except your expression would be =(Fields!NotSuccess.Value/Fields!Total.Vlaue) * 100

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

Answer 2

To add to Calanus's answer, you can format the cell to show a percent via its Right-Click Properties or by using the FORMAT function.

=FORMAT((Fields!Success.Value/Fields!Total.Value), "P")
=FORMAT((Fields!NotSuccess.Value/Fields!Total.Vlaue), "P")

Answer 3

If you are using a matrix then you can use the group to divide by either column or row

Ie.

=round((Fields!count.Value/sum(Fields!count.Value,"matrix1_RowGroup1") * 100,2) & " %"

the field count would be the total of any given category

Example of record set

CAMPAIGN COUNT TYPE

Campaing1 1 Success

Campaing1 4 Not Success

Campaing2 4 Success

Campaing2 4 Not Success