Average in Matrix

Hi Everyone!
I have a question about a matrix in RS.
Its possible to add a Subtotal to a matrix bij right-clicking and Add
Subtotal:
PAUL | 1
MIKE | 4
JOSE | 8
TOTAL | 13
But how can i get the average in this matrix like:
PAUL | 1
MIKE | 4
JOSE | 10
AVERAGE | 5
Thanx,
Mike KlaarhamerHi,
I think (I'm not sure), you can add au subtotal in your matrix and If you
put on the row group principal your field with something like :
Your row | AVG(your field)
the subtotal return you the average of your fields column by column
"Mike Klaarhamer" wrote:
> Hi Everyone!
> I have a question about a matrix in RS.
> Its possible to add a Subtotal to a matrix bij right-clicking and Add
> Subtotal:
> PAUL | 1
> MIKE | 4
> JOSE | 8
> TOTAL | 13
> But how can i get the average in this matrix like:
> PAUL | 1
> MIKE | 4
> JOSE | 10
> AVERAGE | 5
> Thanx,
> Mike Klaarhamer|||Mike,
You can use the InScope-function (in combination with IIF) to determine
whether you are in a total-field during rendering.
You would become something like:
=iif(InScope("matrix1_YourGroup"),Fields!YourField.Value ),RunningValue(
Fields!YourField.Value ,Avg,"matrix1_YourGroup"))
Best regards,
Ive
"Mike Klaarhamer" <MikeKlaarhamer@.discussions.microsoft.com> wrote in
message news:A97160CC-A29C-4012-8D8E-8208FDFEADFD@.microsoft.com...
> Hi Everyone!
> I have a question about a matrix in RS.
> Its possible to add a Subtotal to a matrix bij right-clicking and Add
> Subtotal:
> PAUL | 1
> MIKE | 4
> JOSE | 8
> TOTAL | 13
> But how can i get the average in this matrix like:
> PAUL | 1
> MIKE | 4
> JOSE | 10
> AVERAGE | 5
> Thanx,
> Mike Klaarhamer|||Nope that does not work, post your rdl with a working example.
"Ive" wrote:
> Mike,
> You can use the InScope-function (in combination with IIF) to determine
> whether you are in a total-field during rendering.
> You would become something like:
> =iif(InScope("matrix1_YourGroup"),Fields!YourField.Value ),RunningValue(
> Fields!YourField.Value ,Avg,"matrix1_YourGroup"))
> Best regards,
> Ive
> "Mike Klaarhamer" <MikeKlaarhamer@.discussions.microsoft.com> wrote in
> message news:A97160CC-A29C-4012-8D8E-8208FDFEADFD@.microsoft.com...
> > Hi Everyone!
> >
> > I have a question about a matrix in RS.
> > Its possible to add a Subtotal to a matrix bij right-clicking and Add
> > Subtotal:
> >
> > PAUL | 1
> > MIKE | 4
> > JOSE | 8
> > TOTAL | 13
> >
> > But how can i get the average in this matrix like:
> >
> > PAUL | 1
> > MIKE | 4
> > JOSE | 10
> > AVERAGE | 5
> >
> > Thanx,
> >
> > Mike Klaarhamer
>
>