# New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
Not applicable

## Average per month using Avg/Aggr

Hi, having an issue with getting to a monthly spending customer average and wonder if someone can help - sure it's come up before but not been able to find a fix. The below is an example of the calculation I'm trying to get to, with each particular store as the dimension. So from that table I'd want to show Store 1 - 339, Store 2 - 628 and so on

 Store 1 Store 2 Month 1 342 658 Month 2 350 622 Month 3 301 599 Month 4 312 607 Month 5 378 633 Month 6 371 650 Average 342 628

Using the Avg & Aggr functions gets me to an average across the whole group of stores but doesnt show with the branch as dimension, expression = avg(aggr( sum(SpendingCustomers), Month) ??

Thanks

1 Solution

Accepted Solutions
Highlighted
MVP

## Re: Average per month using Avg/Aggr

May be this

Avg(Aggr(Sum(SpendingCustomers), Month, Branch)

4 Replies
Highlighted
MVP

## Re: Average per month using Avg/Aggr

May be this

Avg(Aggr(Sum(SpendingCustomers), Month, Branch)

New Contributor III

## Re: Average per month using Avg/Aggr

Thank you @Sunny, I want to extract the min and max values on StDev. How could I make this?

Highlighted
Honored Contributor II

## Re: Average per month using Avg/Aggr

Min(Aggr(Sum(SpendingCustomers), Month, Branch)

Max(Aggr(Sum(SpendingCustomers), Month, Branch)

Highlighted
MVP

## Re: Average per month using Avg/Aggr

Min or Max on StDev? Can you elaborate with an example?