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 |
DHL
Starting Member
16 Posts |
Posted - 2007-10-23 : 08:39:26
|
Hello,I have created a matrix in Visual Studio and it looks more or less as follows: BE NL FRCategory1 Item1 100 25 98 Item2 85 142 57Category2 Item1 100 23 89 Item2 85 77 112 ...Now I want to have for every category the subtotals per country (BE, NL, FR) and category. I have used the function subtotals but it gives me only the data of the first record per category. I have looked for a solution here, but it is really not clear to me. Can someone please help?Thanks!Frank |
|
gavakie
Posting Yak Master
221 Posts |
Posted - 2007-10-23 : 16:52:59
|
Why dont you just make groups in a table then get totals off each group then the footer of the table you can get a grand total? |
|
|
|
|
|