OLAP calculation question

[kos_mk]

Hi all
I hope is the right forum.
I need to do this calculation within a cube:

consider this dimension:
[groups].[brands].

I have a measure Val



I need to calculate for every code the average value of Val and summarize the averages to current point of navigation.



How can I define this with MDX?



thanks indeed in advance

Costanzo

[Cynthia_sas]

Hi:
I don't understand what makes this a stored process question. You might want to work with Tech Support on this question. Or, post your question in the Web Report Studio forum, where most of the OLAP users will be participating.

cynthia