
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
How to average of sum of data per month
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
Accepted Solutions

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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))

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Could you share your excel?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
this is the excel.
thank you

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
I meant excel with excel data, formula and output. I will try to get you the same in qlik

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
i hope this is what you meant.
Thank you

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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))

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
It helps me.
Thank you so much
