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.

 All Forums
 Development Tools
 Reporting Services Development
 Subtotal in matrix

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 FR
Category1 Item1 100 25 98
Item2 85 142 57

Category2 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?
Go to Top of Page
   

- Advertisement -