sql server reporting services: Matrix SubTotal Percentage -- sql server reporting services

Matrix SubTotal Percentage

reddy
3/31/2006 3:38:39 PM

sql server reporting services:

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

Re: Matrix SubTotal Percentage

Kaisa M. Lindahl Lervik
4/3/2006 4:55:01 PM

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 Lervik

[quoted text, click to view]