This is my problem:
Region1 Region2 Total
duration % duration % duration %
call1 10 10 90 90 100 100
call2 10 10 90 90 100 100
How I can calculate the %, I need to know the total duration!
Nobody can help me?
abc_abc
Do the following
Divide each column in the matrix by the row total and multiply by hundred. Dividing by the row total is a matter of scope. If you go to the edit group properties in you row group, you can see the name of your row scope. So simply divide the current row,col value by Sum(fieldname,rowscope). Remeber to change all your results to a string and concatentate them. i.e. row val.ToString() + " " + computed percentage.ToString().
I am assuming, that u have a single matrix.
Umer
|||Yes I have a single matrix, but it doesn't work... I m sure I'm in wrong in something.
The group Total is the same of Region1 and Region2, I used the Subtotal by right-click
I have written this expression in the matrix's detalil
=(Sum(Fields!Duration)/sum(Fields!Duration.Value,"matrix_Region"))*100
but something is wrong.
but I don't understand what!|||Now it works, thanks...
In the group'scope I used the "latest" row-groups before datails.
abc_abc
