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 |
|
buraktuf
Starting Member
13 Posts |
 Posted - 2009-05-12 : 10:46:52
|
| Hi to everybody,I have got a problem with matrix. I have a report looks like: May 1 2 3 4 5 6.....-------------------------------------------------------Person1 Salary | 10 3 .................. Foods | 5 11 .................. . | 0 0 . | 0 0 Total | 15 14 ..................--------------------------------------------------------Person2 Salary | 43 5 .................. Foods | 0 23 .................. . | 0 0 . | 0 0 Total | 43 28 ..................I want to calculate the totals for each person according to each day of the month. But i cant find the expression for the field Total in order to get these results. Can anybody help me please? Thanks for any reply.PS: If more info needed to solve, please inform me. |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-05-13 : 11:04:10
|
| did you try adding the default subtotal available for group? |
 |
|
|
|
|
|
Intersection of two scopes in matrix report