Hi, I will rewrite my question.

I'm having trouble to show averages of a measure in a cube, where the normal
aggregation function for a measure is SUM.

I see no AVG aggregation function for measures (I see Min, Max, Count,
Distinct Count and SUM).

If I hide the measure (cost), and create a calculated member based on that
measure, ie Avg(cost), I have te problem of how to average it, since the
cube has two dimensions in the row axis, like:

Time
---------------------------------------
Product |
Customer | avg of cost

If I use avg(nonemptycrossjoin(product.currentmember.childr en,
customer.currentmember.children), measures.cost) I get the same average for
every cell in the cube, what's not corrrect...

Sorry to bother you all, but this thing is becoming a nightmare.

Hope you can help

Michael Prendergast