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

Answer this question

Matrix Subtotal

Matthijs van Kesteren
kindof solved the problem now.. using rows to do the CAN/USA/Total instead of group.
Maratikus
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.
Matrix Subtotal

Answer this question

Matrix Subtotal

Hot Topic

SQL Server

Matrix Subtotal

Matrix Subtotal

Matthijs van Kesteren

Maratikus