[Mondrian] average percentage values with visual totals/totals

Ati Rosselet ati.rosselet at gmail.com
Mon May 13 07:55:26 EDT 2013


unfortuately no, they are calculated inline in the "with" statement. e.g.:




On Mon, May 13, 2013 at 1:52 PM, Paul Stoellberger <p.stoellberger at gmail.com
> wrote:

> Is the measure you are talking about an AVG aggregator value? Meaning the
> percentages are stored as numbers in the fact table and then you create an
> AVG measure on top of that?
> If so VisualTotals() should calculate it fine, in the end its just calling
> Aggregate() on the children
>
> If not, schema / MDX would help
>
> -Paul
>
> On May 13, 2013, at 1:28 PM, Ati Rosselet <ati.rosselet at gmail.com> wrote:
>
> > Hi,
> > We are using visual totals in out mdx, but have an element which is a
> percentage value, and which we would like to show as avg  of the visible
> percentages as opposed to sum (I can't offhand think of a situation where
> one would want to SUM percentages... ).
> >
> > Is there any way of getting visual totals to avg certain elements as
> opposed to summing them?  Or any suggestion as to how this could be set up?
> > Thanks
> > Ati
> > _______________________________________________
> > Mondrian mailing list
> > Mondrian at pentaho.org
> > http://lists.pentaho.org/mailman/listinfo/mondrian
>
> _______________________________________________
> Mondrian mailing list
> Mondrian at pentaho.org
> http://lists.pentaho.org/mailman/listinfo/mondrian
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.pentaho.org/pipermail/mondrian/attachments/20130513/b7b2504b/attachment.html 


More information about the Mondrian mailing list