Hi

Can any one help me out with this problem.

I have an MDX query which i am using to get the aggragation as average instead of default sum aggregation when i browse a measure.

Following is MDX query and i am not getting expected result.

CREATE MEMBER CURRENTCUBE.[MEASURES].[Avg PF167]
AS Avg(([Main Date].[Year],[Main Date].[Month]),[Measures].[Measures].[PF167 Rate]),
FORMAT_STRING = "#,#.00",
NON_EMPTY_BEHAVIOR = { [PF167 Rate] },
VISIBLE = 1 ;




For example. In below sales total, its sum(10+20+10+30+40) =110 by default. But i want (10+20+10+30+40)/5 = 22.


Product Name Sales
----------------------
P1 10
P2 20
P3 10
P4 30
P5 40
================
Total 110


Hope i am clear with my requirement. Please kindly help me and thanks alot for spending your valuable time for me.

Thanks & Regards,

Sunil A.