[Mondrian] average percentage values with visual totals/totals

Paul Stoellberger p.stoellberger at gmail.com
Mon May 13 07:52:37 EDT 2013


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



More information about the Mondrian mailing list