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 |
|
liorlankri
Starting Member
17 Posts |
 Posted - 2006-01-17 : 07:03:52
|
| I have a SQL report that contain matrix. One of it's Column Group contain SubTotal column but it's not work. If I get on the Dynamic Column Group results 2 columns that Data values are 5 and 3, I get in the SubTotal column only 5 and not 8 (=5+3)!!!! It's always show me the value of the first column on the group and not operate Subtotal of all of them.What is the problem???? |
|
|
ditch
Master Smack Fu Yak Hacker
1466 Posts |
Posted - 2006-01-17 : 07:06:28
|
You must specify SUM(Fields!ColumnName.Value) - it must be SUM otherwise it defaults to the first value.Duane.  |
 |
|
|
liorlankri
Starting Member
17 Posts |
Posted - 2006-01-18 : 05:10:46
|
| O.K It's work. Now I want to add column the it's value is the precent of 5 from 8. (5 is the value in the first column and 8 is the SubTotal) How to do this???What should be the expresion? |
|
|
|
liorlankri
Starting Member
17 Posts |
Posted - 2006-01-22 : 05:26:21
|
| Any Idea? |
|
|
|
mallykarjuna
Starting Member
5 Posts |
Posted - 2006-01-25 : 08:23:24
|
| Try out the below expression:<field>.value * 100 / Sum (<field>.value, "<group name>"). |
|
|
|
|
|
|
Problem with SubTotal