Matrix : How to add a column 'total' -- sql server reporting services

direct.media.system NO[at]SPAM wanadoo.fr
11/25/2004 2:47:34 PM

I need to add a column at the right end of the matrix for editing the
sum of the row's fields. I presume that i need to use MDX language but
i don't know how to proceed !

David
12/1/2004 11:33:05 AM

Is it possible to move the column to the left of the data being totaled?

Example
Total F1 F2 F3
Record1 10 2 4 4
Record2 9 3 3 3

[quoted text, click to view]

Robert Bruckner [MSFT]
12/1/2004 8:28:28 PM

Yes. The Subtotal (click on the little green triangle) has a property called
Position which can have two values: After (default) or Before (which is what
you want).

--
This posting is provided "AS IS" with no warranties, and confers no rights.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages about sql server reporting services

sql server reporting services : Matrix : How to add a column 'total'