Matrix-last column not subtotal of row

	Destination Country		Valid Mail
	Austria	Belgium
Austria	1.9	1.7	1
	23	23
Belgium	1.7	9.7	2
	23	23
Valid Mail	1	2	3

hi,

i have some question for matrix:

how to display 'Valid Mail' which is not subtotal for each row.

how to display 'Valid Mail' which is not subtotal for each column.

if reporting services do not have this function, what should i do in order to get the same result using reporting services?

Thanks

Best Regards,

Penny

Hi Penny,

Were you able to resolve this issue?

-Matt

|||

Hi

It seems to me that you may have a similar problem to the one i had.

Please see the following it may help..
http://msdn.microsoft.com/newsgroups/default.aspx?&query=matrix+subtotal&lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=fff4d8a4-5854-4783-9ad7-d73dd3c3c5cb

Matrix-last column not subtotal of row

	Destination Country		Valid Mail
	Austria	Belgium
Austria	1.9	1.7	1
	23	23
Belgium	1.7	9.7	2
	23	23
Valid Mail	1	2	3

hi,

i have some question for matrix:

how to display 'Valid Mail' which is not subtotal for each row.

how to display 'Valid Mail' which is not subtotal for each column.

if reporting services do not have this function, what should i do in order to get the same result using reporting services?

Thanks

Best Regards,

Penny

Hi Penny,

Were you able to resolve this issue?

-Matt

|||

Hi

It seems to me that you may have a similar problem to the one i had.

Please see the following it may help..
http://msdn.microsoft.com/newsgroups/default.aspx?&query=matrix+subtotal&lang=en&cr=US&guid=&sloc=en-us&dg=microsoft.public.sqlserver.reportingsvcs&p=1&tid=fff4d8a4-5854-4783-9ad7-d73dd3c3c5cb

Matrix Subtotal

Hi,

I have a matrix with 3 row groups: Location, Company, Country. I want to add a subtotal of "Company" that will breakdown into "Country" as well.
e.g.
right now if i add subtotal to "Company", it will give me:

New York Company A CAN

100

USA 150 Total 250 Company B CAN 80 USA 90 Total 170 Company C CAN 50 USA 60 Total 110 Total 530 LA Company D etc...

i want something like:

New York Company A CAN

100

USA 150 Total 250 Company B CAN 80 USA 90 Total 170 Company C CAN 50 USA 60 Total 110 Total CAN 230 USA 300 Total 530 LA Company D etc...

is this possible? thanks

kindof solved the problem now.. using rows to do the CAN/USA/Total instead of group.

|||Does anyone know how to actually do this? I have a variable number of members of my groups, so I can't use rows as city_ash did. It seems like relatively basic functionality if people need a matrix report.sql