Wednesday, March 21, 2012

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

No comments:

Post a Comment