Friday, March 23, 2012

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.

No comments:

Post a Comment