Groups | Blog | Home
all groups > sql server reporting services > july 2004 >

sql server reporting services : Show % total?


Chris Patten
7/21/2004 7:23:01 PM
I have a matrix with the total column as the last column. I want a detail field to reflect a % of what the total field is. So something like this, which doesn't work, which is my issue, any thoughts?

Robert Bruckner [MSFT]
7/21/2004 7:34:44 PM
Depending on which total you want, just divide by a sum scoped to the entire
matrix or matrix group name. E.g.:
=Sum(Fields!QUANTITY.Value) / Sum(Fields!QUANTITY.Value, "MatrixName")

--
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]
field to reflect a % of what the total field is. So something like this,
which doesn't work, which is my issue, any thoughts?
[quoted text, click to view]

AddThis Social Bookmark Button