Matrix Report Question

A matrix report look like this:
Cash Bond Stock
account1 $100 $200 $300
account2 $10 $20 $30
How do I add a percent column in each asset class like this:
Cash($) Cash(%) Bond($) Bond(%) Stock($)
Stock(%)
account1 $200 20% $300 30% $500
50%
account2 $100 10% $600 60% $300
30%I have noticed its a pain to manually add a calculated feild in a matrix.
first select any textbox feild in the data area and select add column. it
will add a column at the end of the matrix. it is very difficult to move it
to where you want it to be without replacing what was in the textbox where
you attempted to move it to. so you can try and edit the code and cut both
the static textbox and the static header feilds and paste it to where you
want it. or create the colums as you build it. or create a new feild in your
SQL however the subtotal will not give you the correct %. it will just total
it instead
all in all the matrix is only good for... well...
"bo_dong" wrote:
> A matrix report look like this:
> Cash Bond Stock
> account1 $100 $200 $300
> account2 $10 $20 $30
> How do I add a percent column in each asset class like this:
> Cash($) Cash(%) Bond($) Bond(%) Stock($)
> Stock(%)
> account1 $200 20% $300 30% $500
> 50%
> account2 $100 10% $600 60% $300
> 30%
>

Matrix calculation for percent

How do I write expression to calculate a value to show percentage of the
subtotal value in a Matrix?
I have already tried =Fields!name.value/sum(Fields!name.value) and this
does not work
Example:
Matrix has Coulmn group Matrix_col and a Row group Matrix_Row and I would
like to show the percentage of the subtotal for Matrix_Row in a column next
to Matrix Col.
Matrix_Col Percent
Matrix_Row
value 1 %25
value 2 %50
value 1 %25
Total 4Create a column, and set your expression to Fields!Name.Value /
First(Fields!Amount.Value, "MatrixColumnGroupName") - assuming that your
first row is a total.
If it's not, you might be able to use SUM if you add the Matrix column group
name = Fields!Name.Value / SUM(Fields!Amount.Value, "MatrixColumnGroupName")
Kaisa M. Lindahl
"Curtis" <gilbertson.curtis@.leg.wa.gov> wrote in message
news:uB5u4igFGHA.1028@.TK2MSFTNGP11.phx.gbl...
> How do I write expression to calculate a value to show percentage of the
> subtotal value in a Matrix?
> I have already tried =Fields!name.value/sum(Fields!name.value) and this
> does not work
> Example:
> Matrix has Coulmn group Matrix_col and a Row group Matrix_Row and I would
> like to show the percentage of the subtotal for Matrix_Row in a column
> next
> to Matrix Col.
> Matrix_Col Percent
> Matrix_Row
> value 1 %25
> value 2 %50
> value 1 %25
>
> Total 4
>|||Thank you very much for your answer, I've been looking for a solution for
months.
"Kaisa M. Lindahl" wrote:
> Create a column, and set your expression to Fields!Name.Value /
> First(Fields!Amount.Value, "MatrixColumnGroupName") - assuming that your
> first row is a total.
> If it's not, you might be able to use SUM if you add the Matrix column group
> name = Fields!Name.Value / SUM(Fields!Amount.Value, "MatrixColumnGroupName")
> Kaisa M. Lindahl
> "Curtis" <gilbertson.curtis@.leg.wa.gov> wrote in message
> news:uB5u4igFGHA.1028@.TK2MSFTNGP11.phx.gbl...
> > How do I write expression to calculate a value to show percentage of the
> > subtotal value in a Matrix?
> >
> > I have already tried =Fields!name.value/sum(Fields!name.value) and this
> > does not work
> >
> > Example:
> > Matrix has Coulmn group Matrix_col and a Row group Matrix_Row and I would
> > like to show the percentage of the subtotal for Matrix_Row in a column
> > next
> > to Matrix Col.
> >
> > Matrix_Col Percent
> >
> > Matrix_Row
> >
> > value 1 %25
> >
> > value 2 %50
> >
> > value 1 %25
> >
> >
> >
> > Total 4
> >
> >
>
>