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 |
|
LarryC74
Yak Posting Veteran
94 Posts |
 Posted - 2012-01-20 : 12:46:26
|
| Good afternoon,I'm real familiar with the "InScope" function in a matrix but I've done a lot of reading on how it works.When I created my matrix I only have one group and that's with the column (grpMonth) and lots of rows that aren't group.I'm using IIF(Fields!Field1.value = "Recovered",Sum(Fields!Tot.value),NOTHING) and this will some up properly in the total column of the matrix. What I'm having an issue with is the "percentages" of some the rows.How so you get the total of a matrix to show the correct percentage and correct sums if they are in the "scope"?I have a total of 25 rows...all grouped by Month.LarryEveryday life brings me back to reality |
|
|
|
|
|
Using InScope