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 |
|
i-mardel
Starting Member
1 Post |
 Posted - 2005-11-20 : 21:44:06
|
| Hi!I want to create a Matrix with an additional column in which the total of each row is computed.Right now, I can't figure out how to do this except with adding an additional entry to the dataset and doing a case handling in each cell, which I consider as very ugly.Think there must be a more elegant way to do this.Can anybody help me?Thanks! |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2005-11-21 : 04:16:21
|
you can't do this why?select *, (isnull(col1, 0) + isnull(col3, 0) + isnull(col3, 0) + ...) as RowTotalfrom ...Go with the flow & have fun! Else fight the flow  |
 |
|
|
|
|
|
SSRS Matrix Total