Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  Development Tools  Reporting Services Development  Problem with sum in matrix report

Author  Topic  areefa Starting Member 1 Post Posted - 2005-08-02 : 14:14:57 Hi All, I am new to RS and i have a question in matrix report in my matrix i need to show (leads)/sum(leads) in my matrix i grouped on date, department and counted leads. in one column i need to show leads for each department / sum of leads of all departments, how can i do this. example:Matrix Report ---------7/1/2005----------------------7/2/2005 ---------leads || leads/sum(leads)---leads || leads/sum(leads) dept1-----5 || ?(5/15) 4 || ?(4/12) dept2-----0 || ?(0/15) 6 || ?(6/12) dept3-----10 || ?(10/15) 2 || ?(2/12) Total---15-----------------------------12 can any one know how to refer sum(leads) which is total in the matrix, ? is the one which i am unable to get. Thanks in advance Areefa areefa vallur indymac bank irvine, CA