How to average of sum of data per month

[marthajesicap]

Hi, having an issue with getting to a monthly data average and wonder if someone can help . The below is an example of my data and the calculation that i made in excel:

Date	Name	Weight
1-Jan-21	Ana	0.25
1-Jan-21	Mia	0.31
2-Jan-21	Ana	0.28
2-Jan-21	Mia	0.33
3-Jan-21	Ana	0.26
3-Jan-21	Mia	0.27
1-Feb-21	Ana	0.19
1-Feb-21	Mia	0.3
2-Feb-21	Ana	0.27
2-Feb-21	Mia	0.26
3-Feb-21	Ana	0.24
3-Feb-21	Mia	0.22

Month	How I wrote the formula in excel
Jan	AVERAGE(SUM(D4,D6,D8),SUM(D5,D7,D9))
Feb	AVERAGE(SUM(D10,D12,D14),SUM(D11,D13,D15))

and this is the result that i want to show:

Jan	0.85
Feb	0.74

any ideas?

thank you

[marthajesicap]

i'm having issue with the script. 

i made a new field for Month (Jan, Feb)

and for the calculation
i wrote:

Avg(Aggr(Sum(Weight), Month)

please help me to correct the script.

Thank you

[tresesco]

Could you share your excel?

[marthajesicap]

this is the excel. 

thank you

[tresesco]

I meant excel with excel data, formula and output. I will try to get you the same in qlik

[marthajesicap]

i hope this is what you meant.

Thank you 

[tresesco · Accepted solution]

I missed at the first place, your calculation is actually based upon two dimensions, Month as well as Name. Try:

=Avg(Aggr(Sum(Weight), Month, Name))

[marthajesicap]

It helps me.

Thank you so much