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.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-08-11 : 08:07:25
|
| areefa writes "Hi All,I am new to RS and i have a question in matrix reportin 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 advanceAreefa" |
|
|
|
|
|
matrix report sum problem