Friday, March 23, 2012

Matrix SubTotal Percentage

I have a matrix with dynamic rows and columns. I got the totals for the
Rows and Columns by
right clicking the groups and selecting the SubTotal option.
Can I display the totals in percentage.
[Column1] [Columns2] [ Total] [C-Percent]
[Row1] 1 2 3 50%
[Row2 ] 2 1 3 50%
----
[Total] 3 3 6
[R-Percent](50%) (50%) (100%)
Any help is appreciated.
Thanks
ReddyCreate 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 Lervik
"reddy" <pparlapa@.gmail.com> wrote in message
news:OklmLNQVGHA.6048@.TK2MSFTNGP11.phx.gbl...
>I have a matrix with dynamic rows and columns. I got the totals for the
>Rows and Columns by
> right clicking the groups and selecting the SubTotal option.
> Can I display the totals in percentage.
> [Column1] [Columns2] [ Total] [C-Percent]
> [Row1] 1 2 3 50%
> [Row2 ] 2 1 3 50%
> ----
> [Total] 3 3 6
> [R-Percent](50%) (50%) (100%)
> Any help is appreciated.
> Thanks
> Reddy
>sql

No comments:

Post a Comment