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:
100
i want something like:
100
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