Friday, March 9, 2012

Matrix : How to add a column 'total'

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 !
Thank' for your help.Response : righclick the group column or row header and click subtotal.|||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
"NathalieF" wrote:
> Response : righclick the group column or row header and click subtotal.
>|||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.
"David" <David@.discussions.microsoft.com> wrote in message
news:31D80DA5-EAF4-4ED2-88EC-14F99CFFCB73@.microsoft.com...
> 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
> "NathalieF" wrote:
> > Response : righclick the group column or row header and click subtotal.
> >

No comments:

Post a Comment