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%
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment