Moving Average template

Hi,

I have to include a calculated member in my cube as follows:

I have two figures (X, y) for each month in the year , i need to calculate Sum(X) / Sum(Y) as a % for the previous 12 months.

Can i use the moving average template in the calulations tab?

Assuming that the fact table has one record per month with fields "X" and "Y", and that there is an appropriate time dimension to base the calculations on, then you could try the following approach:

Create cube "sum" measures on each of "X" and "Y" fields.