Problem in Calculating Mean

[#1]

WEEK	GEO	Volume	Mean
1	A	1,108.56	923.51
2	B	2,489.13	1,891.84
3	C	1,351.37	1,025.19
4	A	1,230.70	-
5	B	2,563.97	-
6	C	1,162.73	-
7	A	1,390.05	-
8	B	2,857.79	-
9	C	1,558.26	-
10	A	1,290.58	-
11	B	2,609.77	-
12	C	1,331.18	-

Hi All,

I am trying to calculate the Mean through an expression :

Aggr(Avg(Aggr(Sum({<Product_Id={9},Geo={'Region'}>}Volume),Week,Geo)),Geo)

I need to calculate mean for a period of time for different Regions.

Here A, B, C are Regions.

But I am getting only first 3 values that is for week 1, 2, 3. For Other Weeks , I am getting Null Values. In place of Null Values , the same 3 nos should be repeated across different Regions.

WEEK	GEO	Volume	Mean
1	A	1,108.56	923.51
2	B	2,489.13	1,891.84
3	C	1,351.37	1,025.19
4	A	1,230.70	923.51
5	B	2,563.97	1,891.84
6	C	1,162.73	1,025.19
7	A	1,390.05	923.51
8	B	2,857.79	1,891.84
9	C	1,558.26	1,025.19
10	A	1,290.58	923.51
11	B	2,609.77	1,891.84
12	C	1,331.18	1,025.19

I need to have the result like above table. Kindly Help me.

[Gysbert_Wassenaar · Accepted solution]

Try:

Avg(total <Geo> Aggr(Sum({<Product_Id={9},Geo={'Region'}>}Volume),Week,Geo))

[#3]

Can you please check my discussion, i really need help. Thanks

[#4]

Thanks a lot ..... It works