The following query illustrates a simple example on how to use avg function in mdx.
WITH MEMBER Measures.x as
avg(
descendants
(
[Date].[Calendar].currentmember
,
[Date].[Calendar].[Calendar Quarter]
)
,
[Measures].[Reseller Sales Amount]
)
select
[Date].[Calendar].[Calendar Semester].&[2002]&[1]
.children
on 1 ,
measures.x on 0
from
[Adventure Works]
HTH..
ZULFIQAR SYED
Comments