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 |
|
gavakie
Posting Yak Master
221 Posts |
 Posted - 2010-08-17 : 11:57:41
|
| So I have a matrix with multiple groupings. ON the second grouping I have total on that group, I need to show the percentage of each total.IE I have Group second group second group total I need percent of each in the group % contractor %internal |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-08-17 : 11:59:53
|
| you can add it as additional group headers and in it add expression for percentage of required field.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
gavakie
Posting Yak Master
221 Posts |
Posted - 2010-08-17 : 12:08:30
|
| Can you expand on that a bit i dont quite get it. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-08-17 : 12:17:14
|
| you currently have a group total rite. right click and add two rows of same type and add your expression inside it------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
sums in a matrix