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 |
|
mudunurimadhu
Starting Member
1 Post |
 Posted - 2008-11-07 : 13:34:51
|
| I have a matrix report with one row group and two column groups. I could add sub totals for each of the column groups and row group.Now what I want is,under second column group i have a cell with value from dataset column and i had added another column to show the % of the sub group column value with respect to all values in the second column group. I tried different combinations of scopes and levels but i couldn't accomplish.[ It is something like dividing the second group value with second column group total of that row ]Any help is of great help. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-08 : 05:50:02
|
| just use =SUM(Field!YourField.value,"SecondGroupNameeHere")/SUM(Field!YourField.value,"MatrixNameHere") |
 |
|
|
|
|
|
Matrix Report : Getting subgroup total for second