Matrix subtotals

I have a matrix where the columns show the number of attained grades for a
location along with a subtotal.
Location A B C Passes
London 2 4 5 11
Each grade has a number of points, eg A is worth 4 points, B 3 points etc. I
need to add an extra subtotal column to give me the total points.
Location A B C Passes TotPoints
London 2 4 5 11 30
Is this possible? The reference material suggests that the Total columns are
always based on the other columns. That means I'd have to display the total
points for each grade which the user's don't want.
It gets worse as they also want the average points per candidate.
Have I missed something? Is there a way to do this?
Thanks,
AndrewHello Andrew,
Unfortunately, you could not add another SubTotal Column in the Matrix.
My suggestion is you could add a Table just beside the matrix to show the
SubTotal.
Also, if the Grade column is fixed, you could use a Table instead of Matrix.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||Thanks for the reply. A matrix would've been useful as the number of grades
is variable.
Sounds like an opportunity for extra functionality in the matrix :)
Andrew|||Hello Andrew,
You may submit your feedback to the produce team directly.
http://connect.microsoft.com/sql
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||On Jul 17, 6:22 am, Duke (AN247) <D...@.newsgroup.nospam> wrote:
> I have a matrix where the columns show the number of attained grades for a
> location along with a subtotal.
> Location A B C Passes
> London 2 4 5 11
> Each grade has a number of points, eg A is worth 4 points, B 3 points etc. I
> need to add an extra subtotal column to give me the total points.
> Location A B C Passes TotPoints
> London 2 4 5 11 30
> Is this possible? The reference material suggests that the Total columns are
> always based on the other columns. That means I'd have to display the total
> points for each grade which the user's don't want.
> It gets worse as they also want the average points per candidate.
> Have I missed something? Is there a way to do this?
> Thanks,
> Andrew
For some reason my answer was not submitted.
Press on the column title and right click. From the drop down menu
press "Subtotal", it will add a column that does totals to your
matrix. Hope that helps.|||Hello Ayman,
Thanks for your provide. Your suggestion will create the Subtotal column.
But Duke's issue is that he wants to add an additional column which not
only sum the detail values.
Currently reporting services did not provide such a function for Matrix.
Anyway, thank you for your efforts.
Sincerely,
Wei Lu
Microsoft Online Community Support
==================================================
When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.
==================================================This posting is provided "AS IS" with no warranties, and confers no rights.|||On Jul 17, 6:22 am, Duke (AN247) <D...@.newsgroup.nospam> wrote:
> I have a matrix where the columns show the number of attained grades for a
> location along with a subtotal.
> Location A B C Passes
> London 2 4 5 11
> Each grade has a number of points, eg A is worth 4 points, B 3 points etc. I
> need to add an extra subtotal column to give me the total points.
> Location A B C Passes TotPoints
> London 2 4 5 11 30
> Is this possible? The reference material suggests that the Total columns are
> always based on the other columns. That means I'd have to display the total
> points for each grade which the user's don't want.
> It gets worse as they also want the average points per candidate.
> Have I missed something? Is there a way to do this?
> Thanks,
> Andrew
Right click on the matrix column header and press "Subtotal" from the
drop down menu. That should work.

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