[Mondrian] average percentage values with visual totals/totals
ati.rosselet at gmail.com
Mon May 13 07:57:51 EDT 2013
oops... sent too soon.. sorry.
No.. here we calculate inline as part of the "with" statement. e.g.:
member [Account].[LSYH].[Project %] as '([Account].[LSYH].[Direct result] /
[Account].[LSYH].[Revenues])', FORMAT_STRING = "0.0%"
other values in the rows are plain numbers, so their summing into VT is
On Mon, May 13, 2013 at 1:52 PM, Paul Stoellberger <p.stoellberger at gmail.com
> 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
> 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
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the Mondrian